Change text colour in Slicer

[RAHULBANDI]

Hi 

i have following data,

Account	Availability
American Hospital	0
Aster Group	0
Burjeel Hospital	0
CCAD	0
Emirates Hospital	1
Imperial College	1
NMC	1
Prime Healthcare	1

i have inserted slicer for "Account" column

if the Availability is zero it should show in "red" colour in slicer

if the Availability isOne it should show in "blue" colour in slicer

[Anonymous]

Hi @RAHULBANDI ,

I think you may want to show the account whose availability = 0 in red and show the account whose availability =1 in blue. I suggest you to try conditional formatting in Table visual.

For reference:

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

Measure:

Color = 
SWITCH (
    TRUE (),
    SUM ( 'Table'[Availability] ) = 0, "Red",
    SUM ( 'Table'[Availability] ) = 1, "Blue"
)

Set Account's Background in Cell elements as below.

Result is as below.

Best Regards,
Rico Zhou

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

[RAHULBANDI]

Is it possible to change text colour, Instead of background colour

[Anonymous]

Hi @RAHULBANDI ,

Yes, you can. You can select Font color instead of Background color in Cell elements. Then use the color measure as above steps.

Best Regards,
Rico Zhou

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

[RAHULBANDI]

Hi,

I'm looking for change in text color in Slicer

not in table