Forum Discussion
Which visual as Excel Matrix
Hi 🙂
i try to rebuild a Excel Report in powerbi.
i have some KPI (Mesaures) , but i cant display them as in Excel?
here is the Excel:
and this is my result in power bi:
any idea?
Thanx 🙂
To have the measure titles in the rows, you’ll need to access the visualization settings, under the Values option and toggle the option Show on Rows to ON.
2 Replies
lboldrino , this measure split into measure and dimesion. you need to create table like this with required filter in group by summarize if needed and join back with dimesnions
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])
)To have the measure titles in the rows, you’ll need to access the visualization settings, under the Values option and toggle the option Show on Rows to ON.
