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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.