cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amconnel
Resolver I
Resolver I

Conditional Formatting Disabled when Slicer Selects All

Hello,

 

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.) 

amconnel_0-1626268238683.png

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.)

amconnel_1-1626268300837.png

And, here is a snippet of what the dashboard looks like when I select all in the slicer. There is no conditional formatting.

amconnel_2-1626268372908.png

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?

 

Any help is appreciated!

 

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@amconnel 
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

amconnel_0-1626442408477.png

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

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!