Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Dynamic Change type measure

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.

card-string.png

And the barchart is showing different values:

 

bc-string.png

Measure-mal.png

 

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:

bc-perc.png

 

right.png

 

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?

 

 

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

Use 2 different measures, and vote for my idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15231165-conditional-formatted-me...

 

 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

1 REPLY 1
MattAllington
Community Champion
Community Champion

Use 2 different measures, and vote for my idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15231165-conditional-formatted-me...

 

 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.