Create a DAX Measure to Show Selected Data Points on a Visual - Power BI Tip!
Angelica provides a Power BI tip on creating a DAX measure that helps viewers understand the data points selected in a visual. This measure combines IF, ISFILTERED, VALUES, and CONCATENATEX to display selected values like "Years selected: 2019, 2020, 2021" in a card visual, addressing the common complaint that charts look "wrong" due to hidden selections. The tutorial covers setting up a visual measures table, constructing the DAX measure, and adapting it for different fields, ensuring non-technical users comprehend their reports without disabling cross-filtering. Angelica demonstrates the creation and testing of the card visual and offers final formatting tweaks to enhance clarity in reports. If you help support occasional Power BI users, this approach can reduce confusion and enhance user understanding efficiently.
Video 1m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time