Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @BossCo ,
Based on your description, you want to get the last start date and the first end date of each project, and then use them as slicers.You need to create two calculated columns:
You can refer to the pbix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi V-lianl-msft, my problem is slightly different. I hope to make it clearer now.
Project 1 | 1/11/19 | 10/12/19 |
Project 2 | 5/11/19 | 8/12/19 |
Project 3 | 3/11/19 | 10/12/19 |
Project 4 | 4/11/19 | 8/12/19 |
Project 5 | 1/11/19 | 9/12/19 |
Now, I simply have a slicer for the projects, like this:
What I want is a slicer for the dates, also, based on a calendar table, so that I can filter my fact table (sales) for date and project(s).
I created two measures:
Ok thanks, I'll create two card visuals with the begin and the end date and a warning:
"Please, for coherent data DO NOT SELECT dates outside of this range".
😂
Thanks!
You could create Card visuals with the following measure:
MeasureBeginDate = MAX(Table[begindate])
MeasureEndDate = MIN('Table'[begindate])
Should work when you apply filters, it does in my short test:
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Hi djerro, thanks for the answer.
Yes indeed, it works for the card visual.
My problem is that I should create another date slicer, based on a calendar table, which only shows me dates from the MeasureBeginDate until the MeasureEndDate, that's the point 🙂
Thanks for the answer, I hope it's more clear now 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |