Posts filed under Design & Presentation

Interactive Bookmark Buttons in Power BI

Video by: Reid Havens

In this video you'll learn how to create interactive and website-like bookmark buttons in Power BI using some semi-hidden customization features.

You'll be able to create bookmarks from scratch, and also learn how to add some interactive features to the icon bookmarks as well!

My previous video on how to create bookmark buttons can be found below.

Using Bookmark Buttons to Create Popup Windows

Download Report From The Blog Files Page
Posted on July 17, 2018 and filed under Beginner, Design & Presentation.

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.

Download Report From The Blog Files Page
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!

Download Report From The Blog Files Page

P3: Disconnected Slicers With DAX Variables And SELECTEDVALUES

Article by: Reid Havens

Today’s topic covers how to create a Disconnected Slicer using DAX Variables and SELECTEDVALUES. We’ve easily written a few dozen articles over the years on ways to use disconnected slicers, and here’s another one!

The great thing about DAX is that as it EVOLVES, writing measures and utilizing certain features becomes easier. That’s the goal of this video, it’s not re-inventing the wheel, just refining it. I’ve included below the original DAX Formula I used in the walkthrough. Otherwise, enjoy the video!

Download Report From The Blog Files Page