Posts filed under PowerPivotPro

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!

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!

P3: PBI Spotlight - Using Bookmark Buttons to Create Pop-Up Windows

Video & Article by: Reid Havens

Hello P3 Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe. It’s like Christmas each month for us here at PowerPivotPro, where we get to open the latest updates article and see what the Microsoft Santa brought us this month. Data enthusiasts like us (and you!) can easily get swept up in all the bells and whistles features each month.