Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !!
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
100 | |
93 | |
52 | |
50 | |
48 |