Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX remove filter

Hi,   I have a page that have all the slicers and they are synchronized with all the reports.   In one of the report I want to remove the date slicer, the selection of date slicer in the first pa...
Need Help
  • d_gosbell's avatar
    d_gosbell
    6 years ago
    Anonymous wrote:

    The date slicer is on another page, in this case the edit interaction will not work.

    Sync'ed slicers actually create an invisible copy of the slicer on the synch'ed pages. If you go into the View menu on the page with the visible slicer you can click on the slicer and use the Sync Slicers pane to temporarily make the slicer visible by ticking the check box under the eye icon.

    Then you can edit the interactions on your other page and then change the slicer on your second page back to being hidden.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi d_gosbell ,

     

    Thank you so much for this, it worked, such a simple solution but perfect.

     

    Thanks again.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-lili6-msft ,

 

I figured out that the measure value is accurate, i.e. it is removing the filter, but when I bring month column into the matrix, it only shows the the selected month (as below image). I wanted to show all months. I wanted to show all  the months.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I think the issue is I am trying to remove the filter from the date table, and at the same time I am using the column from the date table in the visual.

     

    is there a work around that other than using another date table?

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Using another table workaround should work

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi Anonymous 

      If so, you need another date table. you could just duplicate the basic date table.

      Then create another relationship as basic date table.

      Now use the fields from this new date table in the matrix visual and set "Show items with no data"

      If you still have the problem, just show a sample pbix file and your expected output.

       

      Regards,

      Lin

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks guys.

         

        Please let me know if there is another solution.

        I have already added the new date table and it is working.

         

        Thanks gain.