Solved: Help

Nihed · ‎02-18-2022

Hello,

How i can swap the axes of the 2 below tables ? I seek to put the banks are in lines and the quarters in columns

Dashboard:

need to display:

v-angzheng-msft · ‎02-21-2022

Hi, @Nihed

You just need to transpose the columns in PowerQuery.

Result:

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How to get your questions answered quickly -- How to provide sample data

View solution in original post

v-angzheng-msft · ‎02-21-2022

Hi, @Nihed

You just need to transpose the columns in PowerQuery.

Result:

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How to get your questions answered quickly -- How to provide sample data

Greg_Deckler · ‎02-18-2022

@Nihed Seems like Bank column in rows and Quarter column in Columns in a Matrix visual but hard to say for sure. You can also use "Show measures on rows"

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...