Forum Discussion
Create crosstab visual from many measures
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,
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
2 Replies
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
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,
