Forum Discussion
Solved
Get conditional Bar Chart Colors for a variable value.
Hello Power-Bi Community, sorry if there is an obvious solution i am quite new. I have 2 values in my data which show calls and expected calls. Both are changing with the selected timeframe and ...
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.
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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thank you!
Works like a charm
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
