Forum Discussion
Matrix Stepped Layout first column show values all rows
Hi all,
I have the following data loading into my Power BI file:
I have disabled the stepped layout, but how can I make it possible to duplicate the value for the date for each row? So that it will be displayed as followed:
| Date | Time | Location1 | Location2 |
| 02/05/2022 | 12:00 | 123 | 2 |
| 02/05/2022 | 13:00 | 21 | 132 |
| 02/05/2022 | 14:00 | 3 | 65 |
| 02/05/2022 | 15:00 | 4 | 435 |
| 02/05/2022 | 16:00 | 53 | 86 |
| 02/05/2022 | 17:00 | 23 | 32 |
| 02/05/2022 | 18:00 | 643 | 867 |
I don't mind if I need do to this in Power Query or with a calculated column. But somehow I do not get it possible to get the format as above in my table/matrix.
Anonymous ,
Have you tried creating two separate measures something like this
Location 1=calculate(<Measure Name>,Location="Location 1")
Location 2=calculate(<Measure Name>,Location="Location 2")
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Hey Anonymous,
My bad, select the location column, go on transform and click on pivot column, select value as Values column ( for you it would be Count)
Best regards,
8 Replies
Hi Anonymous ,
If you need to provide a drill down functionality then as per my understanding you would not be able to get the same output you are looking for as per your query. However you can use a table instead if the drill down functionality is not required.
Hi jaideepnema ,
thank you for your reply. I don't need the drill down functionality, but when I display it as a table it will not be displayed in my prefferred layout. It will display it then as followed:
Anonymous ,
Have you tried creating two separate measures something like this
Location 1=calculate(<Measure Name>,Location="Location 1")
Location 2=calculate(<Measure Name>,Location="Location 2")
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Hey Anonymous,
Go on power query and select the 2 column: location 1 and 2 :Then right click and unpivot column :
Best regards,Hi philouduv,
Unfortunately I want to have it in the layout how you displayed it in the first image.
Below is how the data will be loaded into Power Query
Hey Anonymous,
My bad, select the location column, go on transform and click on pivot column, select value as Values column ( for you it would be Count)
Best regards,