Forum Discussion
qwk
5 years agoHelper I
Dynamic Hierarchy Level
Hi I have a matrix having a 7 level hierarchy, e.g. Product, product category, product brand, customer, customer category, customer subcategory & salesrep. I would like to display to the users the a...
amitchandak
5 years agoSuper User
qwk , There is an option n case of direct query. Maybe you need bring one column values from direct query and try that - https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/