Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
POWER_MI
Post Patron
Post Patron

Change colonne to row on Table

Hi all, 

i have simple question 

on projet Power Bi there are one table like this one 

 

 

Colonne/Rows

 

  Colonnes 0      |         Colonnes 1 = calculation with mesures    |      Colonnes 2=calculation with mesures   

   Row1                          Value                                                                  Value

   Row2                          value                                                              ....

   Row 3

   Row 4  

 

I need to know how it's possible to make like this 

 

         Row1                  Row2                             Row3                   Row4*

Colonnes 1                 same value                   same value .....

Colonne 2

Colonne 3

Colonne 4

 

thanks a lot

1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

Are you using a table or a Matrix? 

image.png


Connect on LinkedIn

View solution in original post

7 REPLIES 7
amitchandak
Super User
Super User

@POWER_MI  In matrix you have an option to show on row. Try that out.

 

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

POWER_MI
Post Patron
Post Patron

Means that on table 

 

 

The Colonnes is Y axe and Rows (line) is X axe

so if possible to reverse 

 

Y will be rows and X will be colonnes ?

Yes exactly

tex628
Community Champion
Community Champion

Add a matrix and make sure you have no dimension on the matrixrow:

image.png

 

Then toggle on the "Show on rows":

 

image.png

 

Let me know how it works! 

 

Br,

J


Connect on LinkedIn

Hi,

thanks for your feed back. In Power BI the table is selected and on option " values no traces of "show on rows like the screen shoot sent?

Capture3.PNGCapture5.PNG

tex628
Community Champion
Community Champion

Are you using a table or a Matrix? 

image.png


Connect on LinkedIn

Hi thanks a lot for your answer. It's table instead of matrix

after update to matrix the rows Display row is appeared and it's work fine.

thanks a lot

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.