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
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.
Solved! Go to Solution.
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
Hope this will help.
Regards
Abduvali
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
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 !
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |