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
I have an advance card and a Stacked column chart, with dynamic measures that looks like this:
Measure =
var meas = min(_Measure[CoMeasure])
return
switch(true();
meas = "Rate%"; 100*[Rate];
meas = "Measure1"; [Events];
meas = other measures.....
)
And as measure:
Rate = [New Device] / [New Total Device]The problem is that in my card, the value displayed "Rate%" it is not showed as a percentage, but, as a number.
And the barchart is showing different values:
Then in the dynamic measure, I change "Rate%" to this:
... meas = "Rate%"; Format([Rate]; "0.00%")
The Card visual it is showing with the right format, but the bar chart is showing nothing.
On the other hand, when I drag the measure "Rate" directly to the bar chart, it is showing the right values as percentages:
What I'm doing wrong? How Can I show the dynamic measure in the card, as % and get the correct values in the bar chart, also showing the right values?
Solved! Go to Solution.
Use 2 different measures, and vote for my idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15231165-conditional-formatted-me...
Use 2 different measures, and vote for my idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15231165-conditional-formatted-me...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |