Forum Discussion

po's avatar
po
Post Prodigy
7 years ago
Solved

Controlling interaction between visuals and filter pane (page)

Hi,   We have one chart which shows a measure by last 10 weeks and don't want this partiuclar chart on page to be affacted by a a year week selection  in the filters pane.   If we have the yearwe...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi po,

     

    If the column is in a visual and it's in the Page Level Filter, I'm afraid you can't clear its effect. We suppose the Page Level Filter can work on the page but it doesn't. That would be a little strange. Maybe you can use a slicer and edit the interaction as a workaround.

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi po,

 

As you used a measure, you can clear the filter in the measure like below.

 

Measure = calculate([the parts already exist], all('table'[Year Week]))

One pre-condition is that the chart doesn't have that column.

 

 

Best Regards,

po's avatar
po
Post Prodigy
7 years ago

Hi,

 

Thanks for suggestion - though chart has that measure.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi po,

     

    It isn't a problem if the chart has the measure. What does the chart have, the measure or the column used as a filter?

     

     

    Best Regards,

    • po's avatar
      po
      Post Prodigy
      7 years ago
      Hi,

      Thanks for reply

      The chart has the measure in the bars and the filter column along x axis

      Thanks
      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi po,

         

        If the column is in a visual and it's in the Page Level Filter, I'm afraid you can't clear its effect. We suppose the Page Level Filter can work on the page but it doesn't. That would be a little strange. Maybe you can use a slicer and edit the interaction as a workaround.

         

        Best Regards,