Forum Discussion
Radar chart - doesnt work
- 10 years ago
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!
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