Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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