I understand what you need, but actually this is quite tricky.
To make this happen, you need to have "dimension" instead of "measure name" on x- axis.
I used "ID" as placeholder to show two measure names.
data I used.
Specify the position of ID, and calculate LOD max to ignore the each ID's score.
filter the ID from display.
Add title header instead of ID.
Hide ID header.
three_measures_SM_10.2.twbx 7.4 KB
Hi, sorry for the late response! Thank you so much for helping me.
This is starting to make sense, I already have the min and max scores and I am having trouble relating my scenario to your example when you use "ID" and "Score".
Can you help me relate this to my 3 measures. I have: min score, max score, delta?
Thank you again!
Sorry, where is your data?
I work for a hospital and cannot share/ upload any of the data or workbooks I work with.
Is there any way you can help?
Can I do this without reshaping the data source?
I have other views using this data and pivoting causes those views to break.
There are couple of ways TO re-shape the data.
But I don't have good idea without re-shaping.
Modifying the other view is one time task and once you decide that, it can be kept.
(I mean the Connection as "pivot" is saved as connection query for future)