Create crosstab visual from many measures

[mq2020]

Hi,

I am trying to create a specific visual to show KPI performance, however I am struggling to build it with the following layout.

Each of the numbers below is a measure in my model, so in the example below I have to put together the 12 measures in this specific format - I'd appreciate any ideas or suggestions. 

Thanks,

[amitchandak · Accepted solution]

@mq2020 , You have to create a table like this and display it on matrix

Display Table = union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))

For icon formatting

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[mq2020]

@amitchandak , the layout is working perfectly, thank you.

However the measure doesn't seem to be shwoing the calculation according to the filters used in the dashboard.

Any way I can work around this? i.e in the filter visual I select a specific country but the table will still show the total number.

Thanks,