Dynamic conditional formating

[Nicolas69]

Dear Community,

I have to use a dynamic conditional formatting for bar chart graphic in Power BI.

After reading several documents, it seems that this is not possible, but perhaps one of you will have a workaround compatible with the way my report is designed.

I explain you what I want to do :

When the user selects an interaction group in the bar graph of the top-left window, such as "order mgmt", this automatically selects the target in the gauge graph below.

Example with another interaction group

Until here all work good 🙂

But at the bottom you can see the trend of the performance by week and for this one I don’t find the way to make it dynamics with my interaction group targets!

For now values are fixed

Here instead of put fixed values, I need to put a formula contains my measure as :

If value >= 0 and < Performance target – 0.1 then RED

If value >= Performance target – 0.1 and < Performance target then ORANGE

If value >= Performance target and < 1 then GREEN

But this is not possible.

Have any of you ever had this need? Do you know of a solution, a workaround?

Thank you very much for your help.

Nicolas

[ray_aramburo · Accepted solution]

Build your logic as a measure and use by Field Value instead of Rules to conditional format. Your measure would be something like: 

Format Measure = IF([% of cases closed < SLA or whatever sum measure you have] >= 0 && [% of cases closed < SLA or whatever sum measure you have] < [Performance target measure] -.1, "#FF0000", IF([% of cases closed < SLA or whatever sum measure you have] >= [Performance target measure] -.1 && [% of cases closed < SLA or whatever sum measure you have] < [Performance target measure],"#FFA500",IF([% of cases closed < SLA or whatever sum measure you have] >= [Performance target measure] && [% of cases closed < SLA or whatever sum measure you have] < 1,"#00FF00", "#FFFFFF")))

I might have missed a parenthesis but you get the idea hehe.

[Nicolas69]

Thank you so much @ray_aramburo it works very good.

more new discoveries today thanks to you!!

Have a nice weekend 🙂