Selecting which account schedule rows will show up as rows in powerbifinance

(0) Share

Report

Posted on by Dave Boehm

645

Does anyone happen to know how to designate a row on an account schedule as a "KPI row" so that it appears in the powerbifinance table?

As an example, the following rows appear in this table for the "M-Balance" account schedule:

DateClosed_PeriodAccount_Schedule_NameKPI_CodeKPI_Name

2017-01-01	True	M-BALANCE	F0007	Total Current Assets
2017-01-01	True	M-BALANCE	F0012	Total Fixed Assets
2017-01-01	True	M-BALANCE	F0013	Total Assets
2017-01-01	True	M-BALANCE	F0019	Total Liabilities
2017-01-01	True	M-BALANCE	F0025	Total Equity
2017-01-01	True	M-BALANCE	F0027	Total Liabilities & Equity

These are the only rows that are selected for that particular account schedule. I would like to have more rows from "M-BALANCE" appear in this table, but I don't seem to remember how to make this happen.

Thanks!

--Dave--

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

If you do not get further traction from this community, you may want to repost here:

community.powerbi.com/.../PBI_Comm_Forums

Thanks.

Was this reply helpful? Yes No