Forum Discussion
DAX remove filter
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.
Hi d_gosbell ,
Thank you so much for this, it worked, such a simple solution but perfect.
Thanks again.
Try Removefilter or Edit Interactions and block the date filter on that visual
https://docs.microsoft.com/en-us/dax/removefilters-function-dax
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
The date slicer is on another page, in this case the edit interaction will not work.
The date slicer is on another page, in this case the edit interaction will not work.
Is the date you are filter is from Date table
?
I tried one matrix and seems to have worked.
Sales With all date = CALCULATE(sum(Sales[Sales]),'Item'[Brand]="Apple",all(OrderTime[Order Date]))Yes, the date is from date table, and I have tried your code, which similar to mine, but it did not work.
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.
Hi d_gosbell ,
Thank you so much for this, it worked, such a simple solution but perfect.
Thanks again.