KPI Dashboard approach

[CloudMonkey]

Hi,

I created a KPI dashboard about a year ago using Power BI but it wasn't possible to fully automate it because it was impossible to do calculated rows.

The workaround I used was to use Power BI to create the data table (using calculated columns), manually export this into a tab in excel and then bring the data into an attractive dashboard tab using index/match lookup formulae. The file is then manually distributed to people by email.

Please can someone tell me if it's now possible to fully automate a report with the layout below? i.e. is it now possible to have calculated rows intersecting with multiple columns (e.g. act/bud and month-to-date and year-to-date) to create a grid?

Thanks for your help,

CM

[v-shex-msft]

Hi @CloudMonkey,

>> is it now possible to have calculated rows intersecting with multiple columns (e.g. act/bud and month-to-date and year-to-date) to create a grid?

Maybe you can try to write a measure with multiple calculation formulas and use switch function to choose which formula to use based on current row label.

Power BI – Using a Slicer to show different measures

For example: create two table as source fields of matrix row and column fields, use selectedvalue function to get current row label, then switch calculate formula based on current row label

Regards,

Xiaoxin Sheng