Unpivot a table with calculated columns & make a table with the info

[iglesias6]

Hello guys, I need some help 'Unpivoting' one table with calculated columns (In power bi) and then use that new table in order to display the unpivot result in a table visualization.

So I have my table named 'Audit Results'. This table has some info coming from an Excel file + my calculated columns:

From my Excel I have these column names:

And from my power BI I added these columns:

So I have that. I want to show a Table visualization which has the following structure:

Atribute                          -      Value

END OF SPRINT DEMO  -       Nice

END OF SPRINT DEMO  -       Poor

END OF SPRINT DEMO  -       Poor

....

EVAL_SPRINTHANDLING -     Poor

EVAL_SPRINTHANDLING -     Poor

EVAL_SPRINTHANDLING -     Poor

How can I do that? Any Ideas?

I believe that the best way is to unpivot my table but I dont know how to do that and then display it on a table visualization.

Please explain in detail if you know!

Thanks a lot

[isjoycewang]

Please consider unpivot the table in Power Query, it's a system automatic function.

[iglesias6]

Yes, that doesnt help at all.

Its easy to do for the columns coming from the excel file of course.

But the problem here is to do it in those AND to do it on the calculated columns that follows them. If you have any help doing that pls respond!

[isjoycewang · Accepted solution]

Hi @iglesias6,

You can try to create new columns in Power Query and then unpivot the columns.

Or you can write a new calculated table as below:

 I create some dummy data for you here, so you could find more details and make it fit in your case.

demo file

Best Regards,

Joyce

[iglesias6]

Yes! That was exactly what I needed it. Thanks a lot!

[isjoycewang]

Great to hear it helps 🙂