Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Icon for Helper II rankHelper II
4 years ago

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

Need Help
Show and Tell

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      RAHULBANDI
      Icon for Helper II rankHelper II
      4 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.