Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can't get my head around this...
What I want to do is create a percentage guage of the 256 over total records 2300. The percentage should work out at about 11% and I want this 11% to be shown as the guage reading with a target of 8%.
How do I get from the table below to a guage which shows the percentage value of the Y records below?
Solved! Go to Solution.
You can also use the built-in Guage visual by dragging proper measures into it.
Best Regards,
Herbert
You can also use the built-in Guage visual by dragging proper measures into it.
Best Regards,
Herbert
Brilliant, thanks it was the syntax in dax I was looking for.
Have you worked out which visual you would like to use?
On the "From Store" button you can get access to some extra visuals, one called a Tachometer should achieve what you are attempting.
To achieve that, after downloading the visual, you would simply need to:
Y Flag Count = CALCULATE( CountRows ('YourTable'[Order]), 'YourTable'[BHLD Y/N Flag] = "Y" )
Thanks so much I'll look at the Tachometer and may be it's a good/better way!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |