Posts filed under Power BI

Power BI Feature Highlight: Many-to-Many Relationships

Video by: Reid Havens

In this video you'll learn about an exciting and recently announced feature for Power BI Desktop...MANY-TO-MANY Relationships. You'll see how easy it is now to connect two tables with non-distinct keys together using this new feature.

Posted on July 25, 2018 and filed under Intermediate, Power BI Features, Power BI.

Creating a DAX Measures Table In Power BI Or Excel

A common pain point when building data models is how to organize your DAX Measures. Learn a great way to organize your DAX measures by creating a table to pl...

Video by: Reid Havens

A common pain point when building data models is how to organize your DAX Measures.

Learn a great way to organize your DAX measures by creating a table to place them in using a semi-hidden feature in Power BI or Excel.

Posted on June 28, 2018 and filed under Power BI, DAX, Beginner, Design & Presentation.

P3: Using Conditional Formatting With Text in Power BI Desktop

Video by: Reid Havens

Today’s topic covers how to apply Conditional Formatting using text in Power BI Desktop. Conditional Formatting recently got a feature update, that allows you to apply color formatting rules based on ANY DAX Measure. I recently encountered a business scenario that had me play around with this feature a bit, and I came up with a clever way to use this for a client. I’ve included below the embedded Power BI report, download link to the .pbix file, and links to other articles explaining the various features & design techniques I’ve applied in this report. Otherwise, enjoy the video!