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 was wondering what the best way to fix this visual would be.
My table in excel to create this visual is as follows (the 3rd and 4th column are actual values I just wrote them like that for the purposes of showing what I'm doing here)
And my tachometer is like this
In this case, the left side is green because the less requests, the better.
When I showed my boss, he said he would rather have only green and red areas, and that he wanted them switched.
So how would I make my table/format this visual to have red (bad/high # requests) on the left side and green (good/low # requests) on the right? I know you can switch the colors in each range but I still don't really know how to manipulate the data to get what he wants in a way that will still show 44 on the bottom.
Thank you! I hope that made sense!
Solved! Go to Solution.
Hi @sy898661
Create measures
end = 0 rang2 = 157*(1/3) rang3 = 157*(2/3)
Drag columns and measures to the following fields
And change colors for rang1 to rang3
Best Regards
Maggie
Hi @sy898661
Create measures
end = 0 rang2 = 157*(1/3) rang3 = 157*(2/3)
Drag columns and measures to the following fields
And change colors for rang1 to rang3
Best Regards
Maggie
Thank you Maggie!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |