Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

Page Level Filters and DAX

Is it possible to connect Page Level Filters with Dax code? Page Level Filters will determine value of the parameters.
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi pstanek,

 

Based on my test, we are not able to reference the page level selected value in a DAX expression currently.

 

In addition, when you select Page Filter value as "2", the table within the report can be filtered and displays  "date2" and "date22".

 

Do you mean the cascading filters? For example, put [Name action], [startdate], [endate] in Page filter, select "2" for [Name action], then other filter fields will be checked by default? Actually, it will not checked filter values by default, but available filter values will display based on previous filter checked value. Please refer to screenshots below:

 

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

I am brand new in this Power BI thingy.

I would like to know the difference between Page level and Report level filters.

Once this is setup, it will only works on the power BI services and not power BI desktop?

 

Please advise.

 

Thank you.

Rudy