The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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.
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