Forum Discussion
Matrix table conditional formatting based on category and value - Dax coding?
Hi there, I am at the final stage of my dashboard and I'm struggling to create conditional formatting based on multiple parameters and could really do with some help please. I have attached a m...
Anonymous , I doubt you can do conditional formatting for row/column fields. You can do series-based colors or column-based
for values, you can use conditional formatting. BUT not for row/column
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
I've used the below dax expression to colour different values based on different conditions in a separate dashboard. Wondering if this can be repurposed for this?
Colour by category =
SWITCH (TRUE (),
MAX('TL Forecast Bookings'[Booking Type]) = "Chargeable", "LightGreen",
MAX('TL Forecast Bookings'[Booking Type]) = "Provisional/Reserved", "Orange",
MAX('TL Forecast Bookings'[Booking Type]) = "Vacation/Holiday", "Yellow",
MAX('TL Forecast Bookings'[Booking Type]) = "Training/Exams", "Violet",
MAX('TL Forecast Bookings'[Booking Type]) = "Non Chargeable", "DodgerBlue",
MAX('TL Forecast Bookings'[Booking Type]) = "Internal Project", "DodgerBlue"
)