Forum Discussion
Build P&L mapping subcategories Matrix visual
Use a measure to hide the row, if they have no subcategory they will have no Value associated with the row. Here for example I have two items:
If I filter the data the item dissapears:
Super UserHi Anonymous If I am understanding what you are asking:
- You don't need those headers rows as the Matrix will still display them in the highest level.
- So Variable - variable - variable isn't required.
- Power BI will automaticall hide cells with no data, so you could create a Measure like so:
- Sales = If( Sum(table[sales]) = 0, Blank(), Sum(table[sales]))
Hi SamWiseOwl. Thank you for your reply.
I need all the headers because I want the possibility to enlarge to 3.Subcategory therefore a need a mapping for all the subcategories even for the lines that have only 1.Subcategory (Variable in this case).
I want to exclude the possibility to enlarge until 3.Subcategory for the lines that don't have that subcategory.
Moreover, for example for operating expenses, it is mapped Operating expenses - Operating expenses - Operating expenses - Operating expenses for the same reason as above, but then when I include it in the matrix I have:
Operating expenses
- Fixed
- Variable
- Operating expenses again
I don't know how to solve this or how should I mapp instead
- SamWiseOwl
Use a measure to hide the row, if they have no subcategory they will have no Value associated with the row. Here for example I have two items:
If I filter the data the item dissapears: