Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I made a simple bar chart visual showing the Percent to Plan for a picker and conditionally formatted the bars to be green if greater than or equal to 100% and red if below 100%.
The below data is the aggregation of an entire week broken down by work area.
On a separate table on the same page, I have the same data broken up by day and when I click on one of the days, the rest of the data filters accordingly.
This is where my conditional formatting breaks and will show a red bar for a work area that is over 100% or green bar that is less than 100% following the week aggregation value instead of the filtered aggregation for the particular day.
Solved! Go to Solution.
Yes I found the solve and its actually pretty simple. You need to find the "edit interactions" button which can be found by first clicking on the date table that is doing the filtering. From there you should see the format option appear between "help" and "Data/Drill"
After you click on edit interactions each visual will have a small popup that looks like this(highlighted):
The options that you are given from left to right are filter, highlight, and none. For our purposes, you are going to want to select filter option and then you should see the conditional formatting work with that particular interaction between visuals. You will have to do this with each visual that you want to use as a filter since the default is to highlight instead of filter like we want. Hope that helps.
@bogilvieiii I'm currently running into the same issue. Did you ever fix yours? I have a bar chart with a measure color conditioning applied to it. When not filtered, it's fine. When filtered, it breaks.
my color conditioning is set up for field value and my field is "color 2" which is below.
I've tried "SWTICH" too.
your previous measure works fine no need to change it. Just follow the steps I laid out in my previous reply back to you
Yes I found the solve and its actually pretty simple. You need to find the "edit interactions" button which can be found by first clicking on the date table that is doing the filtering. From there you should see the format option appear between "help" and "Data/Drill"
After you click on edit interactions each visual will have a small popup that looks like this(highlighted):
The options that you are given from left to right are filter, highlight, and none. For our purposes, you are going to want to select filter option and then you should see the conditional formatting work with that particular interaction between visuals. You will have to do this with each visual that you want to use as a filter since the default is to highlight instead of filter like we want. Hope that helps.
Oh jesus that was it?! Thanks!!!!
Hi @bogilvieiii ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Can you share the rule? I prefer create a color measure and use that under conditional formatting by using field and measure
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Hi @amitchandak
I set the conditional formatting to format by "Field Value" and based it off my "Background Color" which is the following:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |