Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Team,
Source DAta
Category | Sub Cat | Value |
ABC | A | 5 |
ABC | B | 4 |
ABC | C | 3.6 |
ABC | AB | 7 |
XYZ | A | 6.3 |
XYZ | B | 5.5 |
XYZ | C | 6 |
XYZ | AB | 7.6 |
PQR | A | 7 |
PQR | B | 3 |
PQR | C | 6 |
PQR | AB | 9 |
LMN | A | 5 |
LMN | B | 7 |
LMN | C | 3 |
LMN | AB | 8 |
requirement
when user selects two or more categrory from slicer it should distingusih between those category and subcatogry wise value
note- i want to use free RADAR Chart
Output
@amitchandak
Thanks,
Solved! Go to Solution.
Hi @Anshenterprices
If you want to use the free radar chart you need to do 2 things first:
1- Change your data model - Pivot the Sub Cat and Value columns in the Power Query
your table after pivot will be like below:
2- You need to download the Radar Chart by MAQ Software
then add Category to the Category field of the visual and then add all other sub cat columns to the Values area like this :
The output will be like the following image:
And if I select ABC and XYZ in the Category slicer, the chart will be like the below:
This is the free solution, and if you wnat to pay, you can add Radar/Polar Chart - xViz chart to your report and use that.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Hi @Anshenterprices
If you want to use the free radar chart you need to do 2 things first:
1- Change your data model - Pivot the Sub Cat and Value columns in the Power Query
your table after pivot will be like below:
2- You need to download the Radar Chart by MAQ Software
then add Category to the Category field of the visual and then add all other sub cat columns to the Values area like this :
The output will be like the following image:
And if I select ABC and XYZ in the Category slicer, the chart will be like the below:
This is the free solution, and if you wnat to pay, you can add Radar/Polar Chart - xViz chart to your report and use that.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!