Forum Discussion

evertfeyaerts's avatar
evertfeyaerts
New Member
8 years ago
Solved

Issue with Radar chart

Hello,   I have a question about using the radar chart visualization.   I am not able to overlay data on a radar chart by using the slicer visualization. It is not showing any overlay but only th...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi evertfeyaerts,

     

    In your scenario, you may need to create different measures to calculate results for each Sample ID separately, then show all the measures as Y Axis on the Radar chart.

    measure1 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 1"))
    measure2 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 2"))
    measure3 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 3"))

     

    Here is the sample pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi evertfeyaerts,

 

What column are you using as Slicer on your report?

 

Could you be more precisely with your issue by post some screenshots?

 

 

Regards

evertfeyaerts's avatar
evertfeyaerts
New Member
8 years ago

 

Hi v-ljerr-msft

 

I am sorry, I added the wrong data. see below the correct data with some illustrations. The first picture of de radar chart gives me the data of 1 sample and the 2nd picture shows me a "count" of both data and not illustrated separately.

 

Thanks

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi evertfeyaerts,

     

    In your scenario, you may need to create different measures to calculate results for each Sample ID separately, then show all the measures as Y Axis on the Radar chart.

    measure1 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 1"))
    measure2 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 2"))
    measure3 = CALCULATE(SUM(Table1[Results]),FILTER(Table1,Table1[Sample ID]="Sample 3"))

     

    Here is the sample pbix file for your reference. :smileyhappy:

     

    Regards

    • Username1848's avatar
      Username1848
      Frequent Visitor
      2 years ago

      Hello, I have a related question regarding the radar chart in PowerBI. I have a lot of different cases ( like in this example here sample 1, 2 and 3. I have like 100 different and want to avoid writing a measure for each individual one. Do you know a way to work around writing like a 100 measures and still have all "scenarios" visible on the radar chart? It is meant to be filtered, so there will only a few be visible at the same time.

      Thank you in advance!

      BR