Help w/ slicers

[lucasanjos]

Hi forum,

I have a database that shows the results of a school on a given question, and I use this chiclet slicer to filter the questions.

So, I need to know if there is any way to color it with some kind of conditional formatting. The image below, in excel, exemplifies what I mean.

If [Resultado] > [Todos] > 0,5 then  [Questão]---->Green

If [Todos] > [Resultado] > 0,5 then  [Questão]---->Yellow

If 0,5 > [Resultado] > [Todos] then  [Questão]---->Orange

If 0,5 > [Todos] > [Resultado] then  [Questão]---->Red

I don't need a table, i need a slicer or some filter that can be colored. Or any other idea that you guys have. Thanks.

Any help would be greatly appreciated.

[v-xuding-msft · Accepted solution]

Hi @lucasanjos ,

I think you want to configure condition formatting to slicers. Right? If so, unfortunately, it is not supported for now. Maybe you could reference the solution that amitchandak suggests to do it in table and matrix.

You could vote up the idea and submit your request to get the feature fixed quickly.

Conditional Formatting for Chiclets 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

I did not get your condition completely. But using these create a measure which return colors, just like you mentioned

example

Color scatter = if(SUM(Sales[Net Sales])>2500 && SUM(Sales[Margin])>400,"green","red")
//or already created measures

Color scatter = if(([Sum Sales])>2500 && ([Sum Margin])>400,"green","red")

The in Matrix, go to conditional formatting. Hover near measure, You will see three dots. Click and choose conditional formatting.

Once it open choose field as the option and this measure

Also refer

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...