Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelixwow, thanks so much for prompt and well explained solution!!! I appreciate
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |