Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
In my dashboard I have a Gas Guage displaying a percentage between 0%-100%, this is connected to a hierarchy of data and displays the percentage of completion of whatever level of hierarchy is selected. I want to have a card or similar visual that displays whether or not the gas gauge is displaying an average percentage or an exact percentage (Higher levels of hierarchy are displaying an averaged percentage from the level below it, bottom 2 levels of hierarchy are exact percentages). I've tried variations of IF() statements but run into the issue of the card only displaying one of the 2 options. The gas guage is powered by data between 0 and 1. Is this possible?
Thank you.
How to Get Your Question Answered Quickly, meaning please add your work-in-progress Power BI Desktop file along with data source in Excel format using Tables. Please format any DAX using short lines for the reader.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |