98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Power BI - Conditional Formatting
Power BI - Conditional Formatting
Resolved · Low Priority · Version 365
Thu 15 Aug 2019, 09:16Delegate Edmund said...
Edmund has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI - Conditional Formatting
Hi Jens,
(I couldn't find a Power BI specific forum, so posting this here, maybe an idea for the future for a specific one)
CONDITIONAL FORMATTING OF DATA BARS USINGS FIELDS
I have a column chart and want to traffic light colour the data bars depending on a pre-determined thresholds to highlight if data is good/bad.
Presently I had to resort to setting some conditional formatting rules for Red/Yellow/Green based on e.g. >25%, >50%, >75% for instance. What I would prefer is to store these thresholds in a table and set the conditional formatting based on this table.
Thanks in advance.
Thu 15 Aug 2019, 16:44Trainer Claire said...
RE: 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
Thu 15 Aug 2019, 19:52Trainer Jens said...
RE: Power BI - Conditional Formatting
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
Attached files...
pbi con format.xlsxThu 22 Aug 2019: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Utilize Relationships EffectivelyEstablish clear and meaningful relationships between tables in your data model. Proper relationships enable Power BI to navigate and aggregate data accurately. Pay attention to cardinality and cross-filter direction when setting up relationships to ensure the results align with your analytical requirements. |
