Forum Discussion
Dynamic Hierarchy
Hi Anonymous,
Sorry for the delay in seeing this but issues at work.
Althoiugh I have seen some links to make the hierarchy slicer change they are based on values with the same table:
https://xxlbi.com/blog/dynamic-hierarchies-in-power-bi/
Believe that your options is to create 3 matrix visuals one with each hierarchy level order, then create a bookmar for each one and hiding the other two tables then just add buttons and link them to the bookmarks.
Check example attach.
Regards,
MFelix
I have been travelling work related.
I didn't forgot about this. I will answer soon sorry for the delay.
Regards,
MFelix
Hi Anonymous,
Sorry for the delay in seeing this but issues at work.
Althoiugh I have seen some links to make the hierarchy slicer change they are based on values with the same table:
https://xxlbi.com/blog/dynamic-hierarchies-in-power-bi/
Believe that your options is to create 3 matrix visuals one with each hierarchy level order, then create a bookmar for each one and hiding the other two tables then just add buttons and link them to the bookmarks.
Check example attach.
Regards,
MFelix
That is just the exact solutions I was looking for. Thanks a ton. You are a true datanaut.
I will definitely consume this .