The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello community!
i am trying to use conditional formatting on a table.
I have used background colour based on a field.
The field is a DAX with Switch condition.
Unfortunately the results seems to work but is not accurate. As you can see on my print screen, some colours are not accurate. For example 47% should be an orange colour but turns out to be red and so on and so forth.
The Dax is working correctly as it is presented at the end of the slide.
Thank you very much
Thanks for having a look on this...
DAX to define colour is here:
@mgrapsa , Need to check the measure you have used are you getting consistent value from that. One on the right hand side. I do not see a static value of .44.
Make sure measure on right is using all or allselected
can you share the measure formula
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
The Dax of the measure is as follows:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
258 | |
121 | |
117 | |
99 | |
79 |