Forum Discussion
Matrix dynamic rows / multiple hierarchy issue
I am working on a report which needs to be migrated to power bi from tableau
I am facing a issue in matrix rows of power bi.
In matrix visual of tableau, date hierarchy is present as a row. After this date many more rows are present (let's say product row). In tableau, we can hide or show rows inside date hierarchy (month, quarter, etc.) and product row will still be present as it is.
In power bi we cannot go to next row until we drill down completely to date hierarchy. Hence month,quarter,date need to be shown completely to view product row. We cannot hide it.
Is there any way to resolve this issue in power bi ?
Thanks
aniket_kumbhar So this "product" row is not part of the date hierarchy? So basically you have two separate hierarchies in a single visual? That seems weird and unintuitive to me as a report user. Pretty certain you cannot do that in a standard matrix visual so I would recommend a custom visual from AppSource or maybe R or Python. The other way would be to create a table with your row headers and construct a measure similar to:
3 Replies
aniket_kumbhar So this "product" row is not part of the date hierarchy? So basically you have two separate hierarchies in a single visual? That seems weird and unintuitive to me as a report user. Pretty certain you cannot do that in a standard matrix visual so I would recommend a custom visual from AppSource or maybe R or Python. The other way would be to create a table with your row headers and construct a measure similar to:
aniket_kumbhar Maybe some images would help to understand the issue here. I am not clear on the exact problem.
Greg_Deckler @If you see above tableau image, you can see year and other hierarchical rows after that which can be expanded or collapsed using + or - button. Let's say there is another one more row called product which is present after this date hierarchy. In tableau we can show this product row even if date hierarchy is not completely shown. e. g.
Year Product
Year Quarter Product
Year quarter month Product
In power bi matrix visual only way is to drill down completely to get product row i.e.
year quarter month product
Hence user cannot show / change rows
Any ideas on this issue ?
