Date slicer field

Question

Hi,I have a built a simple reporting from an Excel action log.&nbsp;The goal was to copile a monthly reproting with- A chart displaying late actions versus non late actions- A table displaying all the actions currently in progress- A table displaying all the actions created since the last reporting- A table displaying all the actions closed since the last reporting&nbsp;Everything works fine, and to perform the last two tables, I added a date slicer whose "Field" is configured to "Opening date" or "Closed date"It's not optimal though, as the "Field" of the slicer comes from the excel file, I can only filter with dates that exist in my file.&nbsp;I created another dataset with only dates and imported it to my PowerBi desktop dataset.&nbsp;Would it be possible to use one dataset to populate the dates in my slicer (all the dates from 01/01/2016 to 31/12/2030 for example), but to map this filter to another column of my other dataset?This way, I could select any date in my filter, and when it doesn't exist, no data would be displayed at all.&nbsp;If it's not clear, do not hesitate to ask me to clarify.&nbsp;Thanks.

abduvali · Accepted Answer

Hi&nbsp;@Rovand,&nbsp;All you need to do is to create date table in Power BI or use the one exported from excel. Just create a relationship between 2 date fields, see link below to my library where you can download the solution.Follow the link:&nbsp;Network-days&nbsp;Table relationshipDate TableSelecting none existing dateHope this will help.&nbsp;&nbsp;RegardsAbduvali&nbsp;&nbsp;

Forum Discussion

Date slicer field

2 Replies

Related content

Multiple Date Fields

Between Date Slicer

Date Slicer

Date between slicer - Change order

Common date field