cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterMc
Regular Visitor

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

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:

ItemScore
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

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

@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.

2021-02-26_20-48-17.png

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

View solution in original post

1 REPLY 1
jdbuchanan71
Super User II
Super User II

@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.

2021-02-26_20-48-17.png

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

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.