Posts filed under Intermediate

Two Ways to Create Single Value Input Slicers in Power BI!

Learn about two techniques for creating a single value input Slicer in Power BI Desktop!

The first method will apply a technique outlined in a SQLBI article (link below) that uses Tabular Editor to allow native columns (fields) to be modified to allow single value slicer types to be used with them. One consideration is that this technique is not officially supported by Microsoft.

The second method shows you an officially supported method for adding a single value input slicer. This alternative way implements a WhatIf parameter and leverages some clever DAX and relationships to achieve the same result.

RELATED CONTENT 🔗

SQLBI Single Value Slicer
HTML Content Viewer (Daniel Marsh-Patrick)

Video by: Reid Havens

(Livestream Replay) Exploring Azure Synapse Analytics - with Eric Gleiter & Justin Moen

ABSTRACT 📝

Have you considered using Azure Synapse Analytics? You may have wondered how it differs from some of the other Azure tools you're familiar with (such as Data Factory, Data Lake Gen2, SQL Data Warehouse, etc.) and when you should use Synapse over the others. We'll review what Azure Synapse is, how to get started using it, some "gotchas" to watch out for, and we'll show how we help get data into Synapse in an organized and usable way for reporting and analytics in a matter of weeks.

GUEST BIO 👤

Justin Moen is a business intelligence professional who has a passion for working with data and working with his clients to leverage data as a competitive advantage. Over the past 20 years, Justin has worked with many database solutions, such as Oracle, SQL Server, and Snowflake. He is quick at mastering new tools and has a great understanding of current trends in the industry. To complement his technical knowledge, Justin is excellent at working with both business and IT team members to help bring both sides together to produce strategies and solutions that propel businesses forward.

Eric Gleiter is a dedicated and driven application developer knowledgeable in a wide variety of tools. He is experienced in Data Governance and Data Engineering. His ability to learn and digest new information and technologies enables him to quickly understand, implement, and innovate solutions to client’s needs. Eric's mathematics background makes him both flexible and rigorous when it comes to implementing solutions- enabling him to break down complex problems into manageable parts that can be quickly addressed- allowing for fast and effective solutions.

RELATED CONTENT 🔗

Website
Eric's LinkedIn
Justin LinkedIn

Posted on October 14, 2022 and filed under Livestreams, Azure, Beginner, Intermediate, Power BI, Admin & Management.

Alternative Ways to Drillthrough with Hyperlinks in Power BI!

Learn how to leverage hyperlinks and apply filters to navigate to Drillthrough-like pages in Power BI. This alternative approach also has considerations on design and implementation which we'll discuss at length. Tune in to learn more!

Video by: Reid Havens

Posted on October 4, 2022 and filed under Intermediate, Slicers & Filters, Power BI Service.

Customized Bar Chart Using a Matrix Visual + Conditional Formatting?!

Video by: Reid Havens & Gustaw Dudek

Learn how to create a customized bar chart (styled) visual with formatted totals using a native matrix visual in Power BI. This technique will leverage conditional formatting and DAX to reveal the hidden gems of the matrix visual!

GUEST BIO 👤

Gustaw Dudek works as Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.

RELATED CONTENT 🔗

Gustaw's LinkedIn
Gustaw's NovyPro