Forum Discussion
Hide/remove matrix rows
Dear Friend, i have one table with Level1,Level2,Level3,Level4 and value, i want to display in Matrix with hierarchy. Data: Level1 Level2 Level3 Level4 value Asset current bank bank1 ...
i have some restrictions here so that i can't share pbix. this is simple pbix file with sample data:
| Level1 | Level2 | Level3 | Level4 | value |
| Asset | current | bank | bank1 | 10 |
| Asset | current | gs | gs1 | 11 |
| Asset | fixed | land | land1 | 12 |
| Income | Direct | 13 | ||
| Income | Indirect | 14 | ||
| Expense | Direct | expense1 | 15 | |
| Expense | Indirect | expense2 | 16 |
u can develop and test. thanks for your time and cooperation.
pls try againe