Forum Discussion
Get conditional Bar Chart Colors for a variable value.
The measure you need is something like
Conditional Colors = INT( SUM( 'Yor Table'[calls] ) >= SUM( 'Yor Table'[expected calls] ) )
Later you can use it for conditional formatting like on scr below.
This will give you the following result.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hello Mariusz ,
thank you for helping me still.
Let me try to clarify:
This is the normal and wanted behaviour.
This is the normal and wanted behaviour if i filter (drill down in the pie-chart) for the first 4 months.
This is the view if i select the first four months in the piechart without drilling down. It shows a preview for the selected value without really applying the filter. Think it would be great if i could change the colors in this state to the same like in the second picture.
Best Regards
Jonas
You need to change the interactivity as below, by doing this you will start applying filters rather then just highlight.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.