Measures as rows in matrix

[Anonymous]

I'm facing issue with showing some measures as both rows an columns. It's quite special visualisation in matrix and I'm not sure if I can get it.

Except DeliveryID , rest of columns and rows are measures(days1_2,days2_3,.... first deliverydate, last deliverydate (for each station),... from first to last).

Can you please help me on this? If it is possible to have such a combination of measures as rows and columns in a matrix?

[v-janeyg-msft]

Hi, @Anonymous 

The result graph you want has problems. It doesn't belong to a matrix or a table. What do you want to put in the rows and columns of the visual? Is 'Delivery' a row or a column? Can you share some sample fake data and explain more detailed? So we can help you soon.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , do you have measure split on both row and column? Not very clear

For that we usually create a custom table and then display

example

union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)

[Anonymous]

@amitchandak I don't really understand the union you wrote, can you please show your suggestion with an example in power bi report ?

What do you mean by Measure in union? I've many measures.

'..do you have measure split on both row and column?..'

Yes, I have.