Posts filed under DAX

(Livestream Replay) Best Practices for Report Design & DAX in Power BI - with Gustaw Dudek

ABSTRACT 📝

Microsoft Power BI tool consistently provides new features and capabilities to transform the raw data into meaningful insights. Effective UI/UX solutions can be driven by various different functionalities such as, but not limited to: built-in visual-related formatting options (including conditional formatting). In particular contexts, those options can be enhanced ever further by incorporating strategic DAX techniques. By using a combination of the following approaches, including design practices and DAX solutions, it is possible to create reports and dashboards that tell compelling stories from our data in a highly interactive way!

This presentation will demonstrate several practical design & DAX techniques that helps increase report transparency and user experience through the application of certain functionalities, interactions and formatting options.

GUEST BIO 👤

Gustaw Dudek works as the 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 🔗

LinkedIn
NovyPro Portfolio

Introducing the Measure Killer (External Tool) for Power BI!

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out!

GUEST BIO 👤

Gregor Brunner is 34 years old, has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting.

RELATED CONTENT 🔗

Measure Killer (Site)
Measure Killer (Microsoft Store)
Website

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

Download Report From The Blog Files Page

(Livestream Replay) What's new in DAX Studio 3? - with Darren Gosbell

Join Darren Gosbell and I for this live stream and hear about what is new and improved in DAX Studio 3! You’ll discover lots of amazing new capabilities, U/I improvements, feature enhancements, and even DARK MODE. Tune in to learn more!

GUEST BIO 👤

Darren Gosbell is a Senior Program Manager on the Power BI Customer Advisory Team with a passion for Data Visualization and Data Modelling. He has been working with the Microsoft Data Platform since 1999 and has practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Prior to joining Microsoft Darren was awarded as a Microsoft Data Platform MVP from 2006 to 2022 in recognition of his contribution to the community especially in the areas of Analysis Services and Power BI, MDX and DAX. Darren is a contributor to a number of open source projects including DAX Studio, BI Developer Extensions (formerly called BIDS Helper) and ASStoredProcedures.

RELATED CONTENT link🔗

DAX Studio
Darren's Website
Darren’s Twitter

Posted on September 30, 2022 and filed under Topics & Discussion, Livestreams, DAX, External Tools.