The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there
I am trying to highlight the font of anything below 100% as red and anything 100% or over as Green but its not work correctly for me. Below is my configuration:
Can someone help please as I am sure I am doing something incorrectly here but cannot see what.
Solved! Go to Solution.
Hmmm okay, try changing the green row to :
> 1 Number and <= 100 Percent
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Ah yes good spot. However after changing that it still not working as there is an exclamation mark next to it and when I hover my mouse over that icon it says "Please check the logic of this rule".
Ah yeah change the green value to > 99 and <= 100
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you that seemed to have worked. However one more issue is that some of my figures are greater thenat 100% as they have over performed. I cannot seem to say if its over 100% then it needs to be green?
Hmmm okay, try changing the green row to :
> 1 Number and <= 100 Percent
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Boom! It worked thank you! I had to change the order of the rules but that is all sored now thank you so much!
No worries, happy to help 🙂
Hi,
looking at the image you have both number and percentage in the dropdown selectors for the rules. Change them all to percentage
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
82 | |
81 | |
36 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |