Radar chart with columns as categories

[oslosa]

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?

[kentyler · Accepted 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