Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Passing filter selected value to paramater

Hi, Gurus! Sorry if this question was somewhere in forum, but i still didn't find the answer.   I have pDate parameter based on Date query values and FactTable that i want to filter by parameter p...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Anonymous ,

    You said that you want to use parameter in report, visual or page filter, right? But this is not suppported currently. If you want to use parameter to filter it , you could click "edit parameters" , then change it and apply changes like below

    Or you also could achieve this by in design or DAX level instead of Power Query. You could try to create relationship between date table and fact table, then use date table in slicer , which could also filter data in fact table.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Community Support
6 years ago

Hi Anonymous ,

You said that you want to use parameter in report, visual or page filter, right? But this is not suppported currently. If you want to use parameter to filter it , you could click "edit parameters" , then change it and apply changes like below

Or you also could achieve this by in design or DAX level instead of Power Query. You could try to create relationship between date table and fact table, then use date table in slicer , which could also filter data in fact table.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.