Which visual as Excel Matrix

[lboldrino]

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 🙂

[V-lianl-msft · Accepted solution]

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.

[amitchandak]

@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])
)