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.
One additional question, is it possible to call the selected dimensions in the formula for the measure? if i click a month for example it shrinks the bars to a preview value without drilling down. The color stays the same since the month is not used as a filter yet.
Best regards
JonasWillmann
Not sure if I understand the question, but if you use any additional filters the conditional formatting measure should react in the same way, as long as the base measures or aggregations used in the calculation do not have any code that modifies the filter context.
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.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.