You should be able to do this with a calculation. Assuming that your Status Type is your Score Value you can use:
IF [Status Type]=1 then 'Green Circle'
ELSEIF [Status Type]=2 then 'Yellow Triangle'
ELSEIF [Status Type]=3 then 'Red Diamond'
ELSEIF [Status Type]=4 then 'Grey Circle'
Then you can drag this to your Shape Area and choose the associated Shape and Color.
See attached for example.
Shapes_v10.5.twbx 44.0 KB
Thank you for the quick response.
My example may have caused some confusion. I don't have a column called Status Type. The Status Type column was created through the UNION SQL (which isn't an option with SharePoint List - as far as my research can tell)
I have 5 columns: Overall, Scope, Schedule, Resources, Budget. I created 5 calculated fields called Overall Value, Scope Value, etc (screenshots below) to capture the scores from each of those columns and created a Measure Value and break it out using Measure Names
I have 4 values (1 to 4). As an example: Overall could be 1 and Scope could be 2 for the same project on the same date
How am I able to show a GREEN circle in the Overall and a YELLOW triangle for Scope?
Drag Measure Names field to Shapes, then change the shapes accordingly based on your requirement
Hope this helps
Plz mark it helpful and correct to close the thread
Thanks for the help Naveen.
I tried your suggestion. Below are the screenshots.
Basically, placing the Measure Names on Shape applies the same shape on the entire measure and doesn't change based on the value in the measure
Does that make sense? I'm needing the Shapes to be on the value AND have it recognized at the Measure Name level
It makes it a bit trickier if you are using multiple measure types as you cannot drag Measure Values onto Shapes. You can mimic this dragging each Measure up to your Rows and then having a calculation for each measure to decide on shape/value. The most annoying thing about doing it this way is your headers are sideways. To get around this you would need to use the annotation/text to show your headers unless you don't mind them being vertical.
Sideways headers and Sheet Layout
With headers removed and annotations