Forum Discussion

kalyani's avatar
kalyani
Icon for Helper I rankHelper I
7 years ago

Pivot columns using grouping another column

Hi,   I need your help in the below scenario, not sure if there is a possibility to achieve this in PBI.   Here is my table;   I have to group by Batch and Check the Code, if the code oth...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi kalyani,

 

By my tests, I'm afraid that we may not achieve your desired output based on your original table strature in Power BI .

 

As the workaround, you could create the matrix like below.

 

 

Best Regards,

Cherry

kalyani's avatar
kalyani
Icon for Helper I rankHelper I
7 years ago

Hi Cherry, Thank you for your response. Yeah, even I tried creating the matrix, but the table we are trying to create can be used as a input for subsequent analysis and charts.. So, matrix won't help in this case.

 

Regards

Kals