Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
RAHULBANDI
Helper II
Helper II

Change text colour in Slicer

Hi 

i have following data,

 

AccountAvailability
American Hospital0
Aster Group0
Burjeel Hospital0
CCAD0
Emirates Hospital1
Imperial College1
NMC1
Prime Healthcare1

 

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

4 REPLIES 4
Anonymous
Not applicable

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.

RicoZhou_0-1663299008599.png

Result is as below.

RicoZhou_1-1663299035777.png

 

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.

 

 

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

Anonymous
Not applicable

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.

RicoZhou_0-1663307905760.png

 

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.

Hi,

I'm looking for change in text color in Slicer

not in table 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.