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