Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
4 | |
3 | |
1 | |
1 |