Conditional Formatting Disabled when Slicer Selects All
I have a slicer that filters for different segments throughout a couple of matrices below. Depending on what is selected, I want the max/min formatted green/red per row. To do this, I created a measure to use as the field value in conditional formatting for each matrix. This is the measure I am using: (It's a bit more complicated because I have to exclude certain quarters.)
This measure works in all instances, unless I choose to "Select All" in the slicer. This is a snippet of what the dashboard looks like when a specific segment is selected: (There are more years and formatting that are included, but I am unable to share this data.)
And, here is a snippet of what the dashboard looks like when I select all in the slicer. There is no conditional formatting.
Perhaps there is a way that I can alter my conditional formatting measure to account for this issue and fix the problem? If not, do you know of any other solution?
When all are selected, the formatting would be something like that. I placed colored dots next to the numbers that should be colored red or green. It needs to be formatted the same way that the first photo in my original post is formatted.
What I'm doing is taking the max of each row (each quarter and the total rows) and coloring that green. And then similarly, taking the min of each row and coloring that red. Every other number will remain black. There are additional filters in my measure for conditional formatting to exclude quarters that have not yet closed.
The data is showing when I "select all" (please note that I am choosing the "select all" option and not doing a multi-select of all the segments together). However, the conditional formatting is what disappears. There will never be a case when nothing is selected. Perhaps instead of having the "select all" option, I could just have nothing selected. It puts out the same data. However, when I do that, there is still no conditional formatting.
Sorry, I don't know if this is much help for you to better understand what I'm needing here. Could you elaborate more on your idea with the additional measures? Is the "select all measure" necessary if my data is already showing with the measures I currently have? It's simply the formatting that I'm having an issue with.