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.
Hi!
I have a problem with the conditional formatting of a bar chart. Under data colors, it does not show the advanced controls option you would usually get. So I decided to make a calculated column that said the following:
Average Handling Color = IF([Handling Time] <= 5; 1; 0)
I am not that great at making calculated columns, so of course this did not work.
However, I saw a guy do the same thing but basically with a measure. I figured, worth a shot so I wrote the same thing in a measure. When I add the measure to the chart, it will give the correct result, but I cannot place the measure in the legend field in order to conditionally format it "manually", so to say.
I assume I did something wrong with my calculated column or measure and that the solution is close but I cannot find something for the life of me.
Thanks in advance for the help!
Solved! Go to Solution.
hi, @Anonymous
1. Now conditional formatting of a bar chart still Under data colors.
Please move the mouse to the place as below:
2. If you want to use Conditional Formatting on Bar Chart, you could only drag one field into Value
For your case, don't drag Coloring into value, just use this measure for Conditional Formatting.
If you still have the problem, please share a simple sample pbix file and expected output.
Best Regards,
Lin
hi, @Anonymous
1. Now conditional formatting of a bar chart still Under data colors.
Please move the mouse to the place as below:
2. If you want to use Conditional Formatting on Bar Chart, you could only drag one field into Value
For your case, don't drag Coloring into value, just use this measure for Conditional Formatting.
If you still have the problem, please share a simple sample pbix file and expected output.
Best Regards,
Lin
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 |
---|---|
106 | |
105 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |