Matrix Stepped Layout first column show values all rows

[JeroenR]

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.

[jaideepnema · Accepted solution]

@JeroenR ,

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 😀

[philouduv]

Hey @JeroenR,

Go on power query and select the 2 column: location 1 and 2 :

Then right click and unpivot column : 

Best regards,

[JeroenR]

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

[philouduv · Accepted solution]

Hey @JeroenR, 

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,

[JeroenR]

@philouduv thank you! This is exactly what I needed, and with this way I do not need to create several measures.

[jaideepnema]

Hi @JeroenR ,

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.

[JeroenR]

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:

[jaideepnema · Accepted solution]

@JeroenR ,

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 😀

[JeroenR]

@jaideepnema wauw.. How did I not come up with this.

Thanks, it is a bit of setup work but this does the trick!