Forum Discussion
Solved
Need help calculating sum...
Hello! I am very new to PowerBI. I apologize if I can't properly search nor phrase my question correctly. So currently, I have a table that looks like this: Case Number Reject Reason 1 ...
The process you are looking to do is "Unpivot". This is easiest done using Power Query.
Click on Transform Data, then select Transform.
Select your Reason Code Columns, then select Unpivot - Selected Columns.
Then you can create all of your Visuals using this table.
Hope you can get this to work for you.
Regards,
The process you are looking to do is "Unpivot". This is easiest done using Power Query.
Click on Transform Data, then select Transform.
Select your Reason Code Columns, then select Unpivot - Selected Columns.
Then you can create all of your Visuals using this table.
Hope you can get this to work for you.
Regards,
Thank you! This is exactly what I was looking for!
