Learn how to leverage the power of calculation groups to activate inactive relationships without creating multiple measures!
Continue readingEnhance Report Visuals by Highlighting Data Points!
Bring value to the visuals in your report by highlighting data points based on user selection of slicer values!
Continue readingPower Automate Visual and Automatic Page Refresh: Why They Work Well Together
Automatic Page Refresh is not a commonly used feature, but it is very powerful when used in conjunction with the Power Automate visual to refresh Power BI datasets.
Continue readingMultiple Slicers-Use “OR” Condition To Visualize Data
Slicer selection works using “AND” condition. Instead, learn how to visualize data using the “OR” condition when working with slicers from different columns.
Continue readingObject Level Security in 3 Easy Steps
The public preview of Object Level Security in Power BI was recently announced. I will show you how to implement OLS in 3 easy steps using Tabular Editor!
Continue readingComparing Selected Client With Other Top N Clients
Learn how to compare a selected value from a slicer with other Top N values, while also displaying the values based on a rank order.
Continue readingMixing Different Date Granularities on the X-axis
Learn how to mix and display different date granularities on the x-axis of the same visual at the same time, without using the drill up and down functions.
Continue readingImprove UX: Show Year in Legend When Using Time Intelligence Measures
Selecting a certain year in a slicer to show that year and PY’s data in a visual leads to the legend containing measure names. Instead, learn how to show the years in the legend!
Continue readingUsing Conditional Formatting to Display a Message Instead of a Blank Visual
With this conditional formatting technique, you can show your users a message on the visual (using text or images) instead of a blank visual.
Continue readingSimple Trick to Hide Slicer Items
This is a simple trick to hide slicer items in Power BI to make reports more user friendly. This is achieved through simple measures in a visual level filter.
Continue reading