My query follows on from the Financial Reporting in Power BI showcased by Sam.
I recently created:
a Matrix visual for the Balance sheet template report using the TREATAS function. The numbers in the Matrix visual is correct and the balance sheet is accurate
A series of measures for all the subcategories identified in the balance sheet template.
I have now created 2 waterfall charts for both the Total Liabilities and Total Assets analysis
Unfortunately the numbers in the waterfall charts for both liabilities and assets does not agree to my Matrix.
See attached the pbix file . Please advice
BalanceSheet-analytics.pbix (103.5 KB)