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,

 

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