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

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