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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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...