Synchronize slicer date "between" in several page with using a default value

[Anonymous]

Hi everyone and thanks for helpme.

I have a report, that by default in the first page show data form last 4 weeks, I do this adding in the filter level of the slicer date between a filter that show the last 28 day:

Currently, I have two filter, the date and region, If we change these filters, these shouldn´t be appplied until we push the button Apply Filters:

When we push in the button Apply Filters we go to other page similar than the first where these filters are syncronized with the first page and applied in all graphics of the second page:

Until here, all is correct, the problem is when in the first page I push the button of Apply Filters without change the default value of the slicer date in the first page (last 28 days), If I push Apply Filter buttom without change the default value of the slicer date in the first page, the second page show all data that exist in the table in all graphics except in the filter because is synchronized with the first page:

So, when like I push in the first page the apply filter buttom without change the default value of the slicer date the second page are showing in the filter the last 28 day (this is correct) but in the graphic show all data that exist in the table. Currently, I only use a Fact table, I can´t use a dim date table.

How could I do for the both page have the slicer date always syncronized although I don´t change the date and push in Apply Filters? Thanks a lot.

[MFelix]

Hi @Anonymous ,

Do you wnat to always have the 28 days for all pages? If yes then instead of having the filter on the visualization place it on the all pages so you then will have everything page with the filtering.

If you change that value all pages will be adjusted and the small changes will be made with the slicers.

Other option can be to create an additional slicer with a relative option and select the 28 days and then sync with all pages.

[Anonymous]

Hi @MFelix , the first page is for the last 28 days, the second page should be filtered by the selection in the first page, as I commented the filter is syncronized, the problem is when I push the buttom Apply Filter without change the filter of date, instead of apply the current selection, show all data in the table. I don´t know for example if exist an acctions to evaluate if the filter changed and deppend of this go to a one or other page. 

[MFelix]

Hi @Anonymous,

How are you setting up the apply filter? I assume is a bookmarkm so please check if it's connected with the data or not.

If you create bookmark based on all the data of the information and then click on it everytime you select the bookmark the information will be filtered to the first selection, since you have the syncronization between slicers the slicer value is being updated but the rest of the visualization keep the original data.

Try to turn off the data:

Turning off this data when you make changes to slicers the only thing that will update is the visualization, so if you are going to page 2 with sincronized slicer it will be updated.

[Anonymous]

Sorry @MFelix  Im not sure if understand correctly, I have two pages and one bookmark, the bookmark is the initial status of the page 1, because in the page 2 when I want to clear all filter, push a buttom and go to the this bookmark. Im not sure with which element I would have the bookmark that you say, and If is in all page or not, sorry but Im very new with Power Bi, could you explain me with mor details? thanks a lot!!

[MFelix]

Hi @Anonymous,

Maybe I'm not understanding the way your bookmark is working.

When you refer that "because in the page 2 when I want to clear all filter, push a buttom and go to the this bookmark" what is this exactly?

What does this bookmark does?

Is it possible to share the file? or a mockup of you file? If the you have sensitive information you can share it trough private message.

[Anonymous]

Hi @MFelix , here you have the file POC:

https://drive.google.com/drive/folders/1oDOPiMj1w9bZS8yco7kvGKdrDM0whmzU 

In general, the problem is when you push Apply Filter in the first page without change previously the Slicer Date. If you change the slicer date and push the Apply Filter buttom, all is correct, the second page show the data filtered by the slicer date, but if you not change the slicer date and push the apply filter buttom, the graphics of the second page show all data that exist in the table and not the last 28 days that it was the default filter in the first page.

Page1=> Motor Order by Incident Type

Page2=> Filtered Motor Order by Incident Type

Bookmark (Page1)=>Initial Current Day (Initial Page)

Remember that the first page by default show the data from the last 28 days, but the second page should show the data indicated in the slicer Date (format between). In the datasource there are data from 01/04/2020 to 31/10/2020.

Thanks a lot

[MFelix]

Hi @Anonymous ,

I already understood were is your issue first of all there is the need to clarify some concepts.

When tou have the filter pane and you make a filtering on a visualization that filter is only for that specific visualization and not impacting other visuals. This means that when you applied the 28 days to your slicer what you are doing is making that specific slicer visualization (not data) within those 28 days.

The fact that you are reducing the data you are seeing is not impacting the interactions with the other visualizations.

Check image below, as you can see my data is very simple 4 dates only and I make a filter no the slicer and has you can see the chart does not change.

As you notice the filtering of the bar chart is only applied when I make the visualization also filtered in date.

What is happening is that the filter pane is based on the visualization that you select so you are only limiting the values that you are seeing, in case of slicers you are not slicing the data when you place the filter visual at slicer level.

Looking at your report more closely I have check that in the first page you have placed in all visual the 28 days in the second page you have only the filter for the slicer so since it's a visual slicer the rest of the visualizations are not filter as you need because their are not filtered by the data.

My question is what is the purpose of the second page? and what type of interaction are you trying to achieve by redirecting people to the second page?

Using the slicers that you you don't need additional pages.

[Anonymous]

I need the second page, because the slicer filter can´t be applied until the user push the buttom Apply Filter, and initially the slicer filter must to show the values of last 28 last days, If I do all in the same page with different bookmarks, as I have the slicer filtered by the last 28 days, the other bookmarks that should show all data only will show the last 28 days altgouht the range was greater. The big problem is that the slicer date filter always should show the date of the last 28 day until it´s changed by the user.

I thought that other possibilty is a buttom with "Change Filter" and open other page or bookmark with another slicer date without filter, the littel problem is that initially wil show all range of data. Ideally should show only 28 days, but I think that is the only way to do it.

@MFelixWhat do you think?

[MFelix]

@Anonymous ,

What do you consider the appling filter?

In the file you send out any slicer that I select will be applied since the interactions between the slicers and the visualizations is turn on so in this case having the apply button is not really making anything (again looking at the file you have send out). Or I'm missunderstanding what you are looking for?

You want to have a 28 days by default and then if the users changes some filtering the information should be updated correct? 

[Anonymous]

Yes, I want to have a 28 days by default and then if the users changes some filtering the information should be updated correct, but the report shouldn´t update until push the "Apply Filter", the problem is when you push "Apply filter" without change the filter, the graphics of the second page show all data and not the last 28 days.