Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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.
Proud to be a 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.
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 🙂
User | Count |
---|---|
84 | |
76 | |
64 | |
51 | |
46 |
User | Count |
---|---|
101 | |
42 | |
41 | |
39 | |
36 |