Forum Discussion

Nihed's avatar
Nihed
Helper III
4 years ago
Solved

Help

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's avatar
    v-angzheng-msft
    4 years ago

    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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    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"

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    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.