cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Haribaskar89 Frequent Visitor
Frequent Visitor

How to transpose the below scenario?

Hi,

 

I am new to the power bi. I am creating reports using odata and am facing one issue. How to transpose the below scenario in power bi?

 

jgjkgk.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: How to transpose the below scenario?

@Haribaskar89 use matrix visual 

 

- add column1 and column 2 on rows

- add column 3 on column

- add column 4 on values

 

In format pane, change stepped layout off

 

drill down to column 2 by clicking drill down button on top of matrix visual.

 

Hope it helps!!





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




tarunsingla Established Member
Established Member

Re: How to transpose the below scenario?

If you need to change the data model to get separate columns for different values of column3, take a look at the pivoting feature in Power BI to convert rows to columns. Links below for your reference:

https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks#pivot-columns

https://radacad.com/pivot-and-unpivot-with-power-bi

2 REPLIES 2
Super User
Super User

Re: How to transpose the below scenario?

@Haribaskar89 use matrix visual 

 

- add column1 and column 2 on rows

- add column 3 on column

- add column 4 on values

 

In format pane, change stepped layout off

 

drill down to column 2 by clicking drill down button on top of matrix visual.

 

Hope it helps!!





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




tarunsingla Established Member
Established Member

Re: How to transpose the below scenario?

If you need to change the data model to get separate columns for different values of column3, take a look at the pivoting feature in Power BI to convert rows to columns. Links below for your reference:

https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks#pivot-columns

https://radacad.com/pivot-and-unpivot-with-power-bi