Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Nicolas69
Frequent Visitor

Dynamic conditional formating

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.

Nicolas69_0-1720788016544.png

Example with another interaction group

Nicolas69_3-1720788129700.png

 

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

Nicolas69_2-1720788032660.png

 

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

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

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.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
ray_aramburo
Super User
Super User

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.





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Thank you so much @ray_aramburo it works very good.

more new discoveries today thanks to you!!

 

Have a nice weekend 🙂

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.