Forum Discussion
Cannot visualize measure values in bar chart
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
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
2 Replies
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
