Forum Discussion
Helper IVI want to create a RADAR Chart 2.0.2 based on the data
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,
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 !!
1 Reply
- VahidDM
Super User
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 !!