Forum Discussion
rmcconnell340
Helper I
Helper ITrying to Switch Hierarchies Dynamically with Two Columns
Hi, I am trying to create a filter that can change with a toggle based on two different hierarchies I have for the same dataset. I could separate the hierarchies and create a separate column to t...
rmcconnell340 , Check if this option of field parameter can help, but when you toggle, the other slicer value will be lost
Create dynamic slicers using field parameters
https://powerbi.microsoft.com/en-za/blog/power-bi-november-2022-feature-summary/#post-21321-_Toc117515801
rmcconnell340Helper I
Helper IHi amitchandak! That is what I did in the photo above. The Feild Parameter filters between the two hierarchies but the issue is that I need to then filter the hierarchies with another filter and the Parameter does not allow that.
For instance, the Parameter allows me to filter between "department" and "depatment_ext" but does not allow me to filter to GROCERY, FROZEN, ALCOHOL, etc which are specific departments I need to filter the report by.