Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rodbeck
New Member

Date slicer field

Hi,
I have a built a simple reporting from an Excel action log.

 

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

 

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.

 

I created another dataset with only dates and imported it to my PowerBi desktop dataset.

 

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.

 

If it's not clear, do not hesitate to ask me to clarify.

 

Thanks.

1 ACCEPTED SOLUTION
Abduvali
Skilled Sharer
Skilled Sharer

Hi @Rovand,

 

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: Network-days

 

Table relationshipTable relationshipDate TableDate TableSelecting none existing dateSelecting none existing date

Hope this will help.

 

 

Regards

Abduvali

 

 

View solution in original post

2 REPLIES 2
Abduvali
Skilled Sharer
Skilled Sharer

Hi @Rovand,

 

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: Network-days

 

Table relationshipTable relationshipDate TableDate TableSelecting none existing dateSelecting none existing date

Hope this will help.

 

 

Regards

Abduvali

 

 

That worked, the only thing I changed was the relationship that was many to one as multiple actions can have the same start or end date.

 

Thanks a lot !

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.