Forum Discussion
Comparing measures with standard values using Matrix
I tried a couple of strategys (including creating a second table and putting it backwards in my visual), but ended up deciding to drop the idea, and simply work with KPI instead, it wasn't my initial goal, but it ended up serving it's purpose.
That's a rather ambitious project for a noob. You may have to create a separate disconnected reference table with the five bucket values (as text) and then modify your measures to use SWITCH() statements and to calculate according to each bucket.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523