search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
71 stars 24 forks source link

PowerBI - matrix report - Get rid of values from row header rows when row expanded. #250

Open JakiLinks opened 2 years ago

JakiLinks commented 2 years ago

Hello! Would like to figure out how can I get rid of the numbers from below (indicated Blue area). The expected result should be the one indicated Black.

image

Another case is below, the value is even wrong. should be 0 no value. But now there is a negative amount comes from no where... image

Any idea how to fix above please? Thanks a lot.

toresenneseth commented 2 years ago

Hi,

1) We don't currently support any functions which returns whether a row is expanded or not. 2) Not sure where the negative amount comes from. Where does "Compared Period" come from? Is it a custom column, or does it come from your model?

Update: based on the screenshot, the negative value on row 1 seems to be correct, as it is the aggregated value of the descendants?