Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I am trying to get started using POWER BI in my company and I would like to apply this program is the creation of a report on the performance of different structures.
Among the different tools, I would like to use the Radar Chart.
My data is structured as follows:
STRUCTURE | Item 1 | Item 2 | Item 3 |
Structure A | 70% | 90% | 80% |
Structure B | 80% | 90% | 70% |
Structure C | 90% | 80% | 90% |
Structure B | 40% | 80% | 90% |
Structure B | 80% | 70% | 40% |
Structure C | 100% | 40% | 90% |
Structure A | 70% | 80% | 90% |
I would like to have the average percentage of an item on each axis of the Radar Chart. I am only managing to create Radar Charts that have the different structures on their axes (see picture):
The only one that allows me to create them how i would like of MAQ software (see another picture):
The problem is that, when I aggregate the data of the structures or try to display the data of a single structure, it uses a different scale for each axis, effectively making the graph useless (see the last picture):
Is there a solution that does not involve transposing the data? The database is quite large and I have already set up several sections of the report.
Thanks in advance.
Hi @babajat ,
Here are the steps you can follow:
1. Create measure.
Measure 3 =
(
AVERAGEX(FILTER(ALL('Table'),'Table'[STRUCTURE]=MAX('Table'[STRUCTURE])),[Item 1])
+
AVERAGEX(FILTER(ALL('Table'),'Table'[STRUCTURE]=MAX('Table'[STRUCTURE])),[Item 2])
+
AVERAGEX(FILTER(ALL('Table'),'Table'[STRUCTURE]=MAX('Table'[STRUCTURE])),[Item 3]))/3
2. Result:
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi! Sorry for the late response and thanks for the answer.
I'm afraid i have explained myself badly.
The problem is that, when i try to do the radar chart only with one structure (figure 3), the scale for each one of the axis is different rendering the graph useless. Thus i was trying to find a way to change the min-max value of the axis,
I know that other types of charts could be used, but i would be a pity not to use reporting forms that we are already using on excel.
Don't use a Radar Chart. Use a chart type that allows you to freeze the scale on the Y axis.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |