Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table and one of the columns in the table is StatNo which would have a value of 1, 2 or 3. I want the cell to be colored as follows:
1- Green
2- Yellow
3-Red
I set up my conditional formatting as follows:
But it results in the following:
Is it possible to get the results I am looking for?
Solved! Go to Solution.
I sure believe this is possible.
Did you checked whether StatNo column is formatted as number and not as text?
You may also want to change Summarization to Sum.
Regards,
Berat
I sure believe this is possible.
Did you checked whether StatNo column is formatted as number and not as text?
You may also want to change Summarization to Sum.
Regards,
Berat
I switched it to Whole Numbers but I can't do it as Sum because in the case where there were multiple of the same in the Applicaiton field, it produced a sum number in the StatNo field so I have it as Don't Summarize which after adding an additional column produces what I am looking for so Thank You! Another question - is there a way to have it sort so that the highest StatNo is at the top of the list?
To clarify - if possible I would like to have it automatically sort. I know I can click the header and sort it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |