topic Re: Help in DAX Commands and Tips

Help

Nihed — Fri, 18 Feb 2022 19:59:27 GMT

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:

Re: Help

Greg_Deckler — Fri, 18 Feb 2022 20:22:12 GMT

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"

Re: Help

v-angzheng-msft — Tue, 22 Feb 2022 04:46:11 GMT

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.