cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pstanek Member
Member

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.

5 REPLIES 5
waltheed
Advisor

Re: Page Level Filters and DAX

Hi pstanek,

 

Can you clarify your question a bit?

- What do you mean with conect?

- What parameters do you mean?

 

You can check what the filtered values are in your DAX expressions, e.g. with the ISFILTERED() function.

All filters are included in the filter context that is used for evaluating your DAX expressions.

 

Cheers, Edgar Walther
Power BI User Group Netherlands
pstanek Member
Member

Re: Page Level Filters and DAX

Simple example

I have Page Level Filter

Name action

1

2

3.

 

I would like to create Measure=2+ Name action

When page level filter is 2 then measure is 4.

 

The other thing is , I would like to create dynamic table, when table depends on Name action value.  I mean it as filter So I don´t know how. Maybe It is not possible

pstanek Member
Member

Re: Page Level Filters and DAX

Dynamic table

I mean this

Name action startdate endate

1                   date1       date11

2                   date2        date22

 

IF page filter is 2, them l would like to have dynamic filter  value set from date2 to date22.

 

 

Moderator v-qiuyu-msft
Moderator

Re: Page Level Filters and DAX

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".

z1.PNG

 

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:

 

 

z2.PNGz3.PNG

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rudy Regular Visitor
Regular Visitor

Re: Page Level Filters and DAX

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