Forum Discussion
Conditional Formatting in Power BI
Hi, I have a matrix which shows apprentices and planned end dates, with amounts paid per month for training. I want to highlight any payments made after the end date but I can't figure out how t...
Just realised I didn't mention how you use this measure, sorry! You will want to click on the matrix visual with your data then navigate to cell elements and select the value you want to apply this to:
Then turn on the conditional formatting you want to apply (I have chosen background in this case) and click the Fx button next to it, this should open this window for you:
Click the dropdown on Format Style and choose Field Value, then in the 'What Field should we base this on?' field, choose the measure you created (in my case it would be 'Conditional Format Value').