Cannot visualize measure values in bar chart

[zxl1031]

Hello everyone,

It is a weird thing that I am able to visualize(show) measure value in a table  but not as a bar chart.

this is the pbix file I am working on. You can download it  My Pbix

Thanks!

Shirley 

[MFelix · Accepted solution]

Hi @zxl1031,

You issue is on the % Automate and % Rewrite measures, you are using the FORMAT option in your measure so you are turning these two measures into text so any other measures that are deriving from this two are also text measures, and text cannot be put in a chart.

You need to make you measures without the format and on the modeling tab make it a percentage then you can use them in your table or bar charts.

Check the PBIX file attach revised.

Regards,

MFelix

[zxl1031]

@MFelixwow, thanks so much for prompt and well explained solution!!! I appreciate