Power BI - Conditional Formatting

Hi Edmund,

Jens has been training today so has not been available to comment on your question.

I have assigned it to him and he will get to it at the first opportunity.

thanks
Claire

Hi Edmund,

Thank you for the forum question and thank you for the nice feedback. I also guess that you are the Anonymous Engineer, who gave me an amazing Trustpilot review. If it is, I will send you a huge thank you.

I have found a solution which may work for you. I have attached two files. An Excel work with the threshold you can change as much as you like, and a Power Bi file.

If you look at sheet1 in Data view in the data model in the Power Bi file, I have done two column DAX calculations. One to find the right threshold and one to lookup a value (1, 2, or 3). I use the looked up value for the conditional formatting in the chart.

Remember to change the connection path to the Excel files so you can refresh if you change the threshold in the Excel files.

I hope it makes sense otherwise please come back to me.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector