Forum Discussion
Radar chart - doesnt work
Hello.
I've installed custom visual from the gallery called "Radar Chart" and for some reason cant get it to work the way I need it.
My data looks like this:
Criteria1 Criteria2
EmployeeName Mark/Number
Example:
Toys Sales Appliances Sales
John Smith 5 3
Excel generates radar chart with that data without a hassle, but not the power bi.
When I add criterias data it fills out radar entirely for every criteria.
Any suggestions?
Thank you.
Hi there! Power BI works best with column-based data, so you want it in this sort of format:
EmployeeName Criteria Mark
John Smith Toys Sales 5
John Smith Appliances Sales 3
In Query Editor there's a great 'Unpivot' function that will help you out. Here's a guide for Power Pivot but the principle is the same:
Hope that helps!
9 Replies
Hi there! Power BI works best with column-based data, so you want it in this sort of format:
EmployeeName Criteria Mark
John Smith Toys Sales 5
John Smith Appliances Sales 3
In Query Editor there's a great 'Unpivot' function that will help you out. Here's a guide for Power Pivot but the principle is the same:
Hope that helps!
For powerbi desktop, it doesn't .
Compare
https://www.youtube.com/watch?v=KRX4tmflYGg&feature=youtu.be
and the actual when you install.
Categories is here,
Y-axis is there
Values are missing.
Please advise
Same here. On desktop version the radar visual is not working cause the values field is missing. Without this, this visual is useless. Could you pls update it ASAP?
I got it to work by the method suggested by WillT. This technique is nothing I like though, I've never needed to use it for other chart types.
Also this chart type becomes quite useless when it doesn't seem possible to set different max values for different axes, forcing me to normalize to get an acceptable look for the chart (but then the values are difficult to understand instead).
