Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
User | Count |
---|---|
84 | |
79 | |
71 | |
47 | |
42 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |