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 the "first", "last" or count result.

 

My data looks like this:

I would like to overlay sample 1 or 2 or 3 or ..., depending on which I would like to see with category A till M as the "category".

 

CategorySample 1Sample 2Sample 3
A10.90.8
B1.110.9
C0.81.10.7
D1.31.21.1
E1.91.30.4
F1.51.41.3
G0.51.50.6
H0.91.61.1
I11.51.6
J1.41.81
K21.91.8
L2.10.81.9
M1.30.80.7

 

Can somenody help me solve this?

 

Thanks

 

Evert

  • 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

5 Replies

  • 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