Putting Measure into a datatable so they can be used in a radar chart

[PeterMc]

Hi folks

I am trying to use a radar chart to show the balance between cost, risk and performance with each having it score on it's own axis (hope that makes sense). To generate the visual I need to have a 2 column table with the name of the item and it's associated value, like this:

Item	Score
Performance
Cost
Risk

My problem is that each Score comes from a different measure and this doesn't provide me with the visual I am after. Does anyone know if I could generate a table as above where the values in the Score column come from different measures?

Thanks

Peter Mc

[jdbuchanan71 · Accepted solution]

@PeterMc 

You can create a table that has the three score types in it like so.  The "Order" column is simply there if you need to sort the items into a particular order for display.

Score Types = 
DATATABLE (
    "Item", STRING,
    "Order", INTEGER,
    {
        { "Performance", 1 },
        { "Cost", 2 },
        { "Risk", 3 }
    }
)

Next we write a measure to read the Item from the Score Types and return the correct measure.

Scores = 
VAR _Item = SELECTEDVALUE ( 'Score Types'[Item] )
RETURN
SWITCH(
    _Item,
    "Performance",[Performance Measure],
    "Cost",[Cost Measure],
    "Risk",[Risk Measure]
)

Now add the 'Score Types'[Item] column as the category and the [Scores] measure as the axis to the radar chart.

I have attached my sample file for you to take a look at.