Forum Discussion
Remove empty row headers from matrix
Dear PowerBI experts, I hope one of you has a solution to the following. I am building a P&L report. The rows are derived from a multi-level account hiearchy where level 1 is the highest lev...
Anonymous you can put a fiter against your values like below which will show only values greater than o so blank value column/row header will not appear
and to remove +/- icon, under the row headers section, please off the below selection
thanks. let me know if you are able to resolve your issue.
Thank you for your rpely.
In my example, the values are actually not blank or 0. It is the row header that is blank. Unfortunately, enabling the filter on either the AccountLevel3 or Value to filter out zeros and blanks does not make a change.
Update: Adding a filter on AccountLevel3 to filter out empty records hides the whole row completely including the higher level, but that is not what I want...