Column to rows for measures

[ApurvaKhatri]

Hi, I have a measure value New-Pay, Old-Pay and Difference.

I have picked the values in the table as follows.

FirstName LastName  New-Pay  Old-Pay   Difference   

John          Bolt           2000         1500         500

However, my manager wants it to be displayed as:

FirstName John

LastName Bolt

New-Pay 2000

 Old-Pay  1500

Difference  500

Which visualization should I use? How is is possible??

Thanks.

[alena2k]

Try multi-row card and formating options for it

[Omega]

You can try to unpivot the table in the query editor and then create an indexing column.

Create a copy of your table

Once you create your table, click on "Edit Queries" in the home ribbon. -> Select your table -> Select all the columns in table

-> Click on transform ribbon -> then click on "unpivot columns"

Click on "Add Column" and the click on "Index Column", this is for clustering and sorting your rows. Otherwise, the sorting will be alphabetically. 

Power BI will create three columns: Attribute, Value and Index (You can change the name). 

Apply the the changes -> Create table -> Drag all three columns and then hide Index and by decreasing the width of the column. 

Hope this helps. 

[ApurvaKhatri]

These are possible for existing columns in a tabel. But are they possible for measures created on a table?

[Omega]

Can you please ellaborate? 

[ApurvaKhatri]

I have measures in a table. I want to unpivot measures but I cannot see them anywhere in edit queries. Is it possible to unpivot measures? How?

[Omega]

It's not possible to unpivot measures. 😞

My solution is based on number of KPIs per customer.