Forum Discussion
(+/-) Icon behavior with the matrix hierarchy
I had many blanks values in the matrix hierarchy due to asymmetrical hierarchy levels. I managed to hide them with this metric : Remove Blanks = SWITCH(TRUE(), AND(ISINSCOPE(hier[Level 2]),ISBL...
Hi Anonymous,
AFAIK, power bi will auto-hide the row if all column fields do not contain corresponding records.
BTW, SWITCH function not suitable to compare with summarised values, if multiple conditions matches, it always returns the first condition they match. So I think your formula does not work for your records, can you please share a pbix file for test?
In addition, it seems like your formulas also expand these 'hidden' rows. I'd like to suggest you add filters in your calculations formulas to ignore the calculation on the above rows to prevent the fill down '0.0' results on specific rows.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng