Forum Discussion
Conditional Formatting Disabled when Slicer Selects All
Anonymous
But how do you want to the table looks like when selected all segments(or no selected)?
You might need to create another measure to show data when selected all, then use isfiltered to display both selected status and not selected status.
So you need 2 measures:
1. select all measure = xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2. Result measure= Isfiltered(max([Segments]),[your format measure], [select all measuremeasure])
Paul Zheng _ Community Support Team
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.
Thanks