Slicer color (by changing)

[Anonymous]

Hello Community,

i have several slicer on a page (cause i need it). The slicer have always the value "All" or "different Data"... well if it possible to change the color (backgroud or text) somewhere (in the slicer) if the slicer value isn´t "All"?

thx

[westwrightj]

Hey Kolie,

   You sure can change the color based on the filter selection

    First you want to make a measure to define what colors you want to swap between

    In this case we will say we want the background color to be white when all is selected and blue when other items are selected

Selected Color =

IF(SELECTEDVALUE(Test[Column1]) = "All", "#f8f8f8", "#6194a3")

Next we will set the background color to use this measure in the visual you want to have change

Now just try out your filter and see the color change

 

 

[Anonymous]

Hi @westwrightj ,

ok, i tryed Your way... well, lessons learnd:
1. it works, but u can´t change the slicer-color itself, but u can change something esle.. in my case i use a textfield netz to slicer.
2. Value "All" is in my case "" 

3. But waht is the value of "Multi select"?

Ty

[Anonymous]

🙂

no, no, no 😄 this isnt the task.

I wanted to change the color in slicer not in visual. Look, i want to see if slicer is not according to value "all", cause i have too many of them... visuals still have the same colors.

example

- slicer 1 : customer [Value "All" , or Number]

- slicer 2:  cost unit [Value "All", or selected cost unit]

so if slicer 1 isnt "all" then change bg color of slicer....

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

Based on my test,it is not supported  currently. You can propose your new idea via below link and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , In slicer Background color conditional formatting is allowed.

Create a measure like this

color measure = if(isfiltered(Table[Column]),"Red","Green") // isfiltered false means all.

Now use this with option Field in the conditional formatting

Steps:

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

also referv

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/