Matrix table conditional formatting based on category and value - Dax coding?

Question

Hi there,&nbsp;&nbsp;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 mocked up table of how my table appears. I am looking to create conditional formatting based on Grade and the specific value based on utilisation expectations for that grade. I've chosen to use mock data just to represent the data and not risk any issues with data protection/GDPR.&nbsp;Grade expecations:Director: 50+ Green, 40-50 Amber, &lt;40 RedSenior Manager: 65+ Green, 55-65 Amber, &lt;55 RedManager, Senior Associate and Associate: 75+ Green, 65-75 Amber, &lt;65 Red&nbsp;(Merged cells were taken out when this was posted. For reference, there is a PW, P4W and YTD column under each grade. Sorry!)Grade1 Director2 Senior Manager3 Manager4 Senior Associate5 AssociateLoSPWP4WYTDPWP4WYTDPWP4WYTDPWP4WYTDPWP4WYTDX405060807580659070605090704080Y505060607065807580806080906050Z2040704045707080759070601008560&nbsp;Thank you so much in advance!Screen snip of example table:I've used this DAX expression for a matrix table in a different dashboard, was wondering if this could be repurposed?Colour by category =&nbsp; &nbsp;SWITCH&nbsp;(TRUE&nbsp;(),&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Chargeable",&nbsp;"LightGreen",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Provisional/Reserved",&nbsp;"Orange",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Vacation/Holiday",&nbsp;"Yellow",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Training/Exams",&nbsp;"Violet",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Non Chargeable",&nbsp;"DodgerBlue",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) =&nbsp;"Internal Project",&nbsp;"DodgerBlue")

nishpatel · Answer

You can use cell elements property under visual property to conditionally format each series.&nbsp;&nbsp;

anonymous · Answer

Thanks for the quick response Nish. That seems to apply it for PW/P4W/YTD irrespective of Grade unless I am missing something?

amitchandak · Answer

Anonymous , I doubt you can do conditional formatting for row/column fields. You can do series-based colors or column-based
&nbsp;
for values, you can use conditional formatting. BUT not for row/column
&nbsp;
How to do conditional formatting by measure and apply it on pie? https://www.youtube.com/watch?v=RqBb5eBf_I4&amp;list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8Lhttps://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

anonymous · Answer

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?&nbsp;Colour by category = &nbsp; &nbsp;SWITCH (TRUE (),&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Chargeable", "LightGreen",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Provisional/Reserved", "Orange",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Vacation/Holiday", "Yellow",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Training/Exams", "Violet",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Non Chargeable", "DodgerBlue",&nbsp; &nbsp; &nbsp;MAX('TL Forecast Bookings'[Booking Type]) = "Internal Project", "DodgerBlue")

padycosmos · Answer

Hope this video helps:https://www.youtube.com/watch?v=7veYU1EeO6w

Forum Discussion

Matrix table conditional formatting based on category and value - Dax coding?

5 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting

Grade	1 Director	2 Senior Manager	3 Manager	4 Senior Associate	5 Associate
LoS	PW	P4W	YTD	PW	P4W	YTD	PW	P4W	YTD	PW	P4W	YTD	PW	P4W	YTD
X	40	50	60	80	75	80	65	90	70	60	50	90	70	40	80
Y	50	50	60	60	70	65	80	75	80	80	60	80	90	60	50
Z	20	40	70	40	45	70	70	80	75	90	70	60	100	85	60