Forum Discussion
Matrix dynamic rows / multiple hierarchy issue
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 ?