Forum Discussion
Adding new rows to report
That you can do - for example with a measure that you then add to the page level filters.
" I would like to show an additional row in the report"
That is very hard to do in Power BI. You would have to maintain two separate tables , one with payments that are related to invoices, and one with payments that are not. Then you would need to append these tables in Power Query, and then use filters to not show certain rows.
In Power BI You can dynamically "remove" (filter) content. You cannot dynamically add content.
Hi lbendlin ,
actually I tried to append the tables Power Query, but it did not help. The report is strucuted by a Project / Invoice hierarchy. If I cannot add somehow a row to the "AInvoiceCalc" table or even "only" in the report, then what I would like to do might not be possible as you say. I might try at a later stage once again.
In relation to dyamically filter content I would to ask you the following.
Now I have a slightly changed data model:
I have created an additional table which returns one column only containig any INVOICECODE fully compensated by a creditnote. That table "FilterFullyCompensatedInv" has a relationship with the table "AInvoiceCalc".
I would like to filter "AInvoiceCalc" in order that it does not contain any Invoices which are contained in "FilterFullyCompensatedInv" if possible only for one page of the report, for other pages "AInvoiceCalc" should not be filtered.
Best regards
That you can do - for example with a measure that you then add to the page level filters.
