Forum Discussion
Conditional Formatting bar chart visual breaks during filtering
- 3 years ago
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.
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: