Forum Discussion
Anonymous
3 years agoNot applicable
Hierarchical filters for parameter values
Hi PBI community! I created a simple parameter (in my example ‘Parameter’) and have a slicer for it. It works great! But what I need is, based on the parameter value chosen by the user, I need to gi...
- 3 years ago
Hi Anonymous ,
This is my test table:
Transform in the Power Query:
You will get a table like this:
You will get result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yadongf-msft
Community Support
3 years agoHi Anonymous ,
This is my test table:
Transform in the Power Query:
You will get a table like this:
You will get result you want:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.