Forum Discussion

StuBee's avatar
StuBee
Helper I
6 years ago
Solved

Visual Level Filters Relative to Page Level

Hi All,   Would anyone know if it is possible to have a visual level filter relative to the page level filter.   For example, having a graph that is set to view last 5 days of work from today (24...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi StuBee ,

     

    Please refer to the measure below instead of a visual level filter.

    Measure = IF(SELECTEDVALUE('Table'[date])>CALCULATE(MAX('Table'[date]),ALLSELECTED('Table'))-5,1,0)

     Result would be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi StuBee ,

 

Please refer to the measure below instead of a visual level filter.

Measure = IF(SELECTEDVALUE('Table'[date])>CALCULATE(MAX('Table'[date]),ALLSELECTED('Table'))-5,1,0)

 Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI gives users the ability to fine tune how a slicer impacts the appearance of other visuals on the report canvas and vice versa. Enabling the Edit interactions option on the Format tab gives authors more options for controlling filters on a per-visual basis.