Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
evertfeyaerts
New Member

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

1 ACCEPTED SOLUTION

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"))

r4.PNGr5.PNG

 

Here is the sample pbix file for your reference. Smiley Happy

 

Regards

View solution in original post

5 REPLIES 5
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @evertfeyaerts,

 

What column are you using as Slicer on your report?

 

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

 

r2.PNG

 

Regards

 

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

 

data radar chart.JPGpower Bi radar chart.JPGpower Bi radar chart 2.JPG

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"))

r4.PNGr5.PNG

 

Here is the sample pbix file for your reference. Smiley Happy

 

Regards

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

Perfect! It works, thanks @v-ljerr-msft

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.