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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
v-rzhou-msft
Community Support
Community Support

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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.