Filters

[JanCronje16]

Hi, I have a report that has deals with asset inspections, condition and defects and give the users information on inspection and defect numbers for a month that is selected by them through a slicer.

The report has 5 pages  and throughout the report I refer to two different dates for which have slicers on the differeent pages to enable the user to udjust the date from any page. I have synced each of these dates over the page and some of the pages contains both of these dates.

I can get the value of any one of the date slicers using the Values function. I want to use this to set the other slicers/filters so the users only have to adjust the report date in one place. Is this possible and if so how do I do it?

[mhossain · Accepted solution]

@JanCronje16 

I understand you have two separate dates and going to separate slicers, better to create a Date Dimension table and make relationship with tables, in this way you will have slicers based on single date source. You can search on google for date dimension table or read this blog https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

Hope this helps.

[JanCronje16]

Thanks, I'll look into this.

[amitchandak]

@JanCronje16 , You can sync the other date too? not very clear on this.

[JanCronje16]

I can sync the creation date slicers on all pages and I can sync the inspection date slicers on all pages but I looking for a way to sync the creation date slicer with the inspection date slicer.