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.
Hi, I have a large dataset where each row represents a project and each column represents a project attribute. I want to display these attributes in a radar chart for each project.
The problem is that the radar chart requires the axes/categories to be rows in a single column rather than columns for a single row, i.e. it requires me to transpose my data. As the dataset is used throughout the report in it's regular shape I do not want to do this, and as the dataset is large I do not want to make a transposed copy of it either.
Is there a workaround?
Solved! Go to Solution.
I made a sample table
and then I was about to create a calculated table using UNION() and SELECTCOLUMNS()
But for a large dataset I'm afraid it will be very slow.
It might be better to bite the bullet, load your data in this form, and transform it for the other visuals you are using.
I'm a personal Power BI trainer
Help when you know. Ask when you don't!
I made a sample table
and then I was about to create a calculated table using UNION() and SELECTCOLUMNS()
But for a large dataset I'm afraid it will be very slow.
It might be better to bite the bullet, load your data in this form, and transform it for the other visuals you are using.
I'm a personal Power BI trainer
Help when you know. Ask when you don't!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |