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.
I have a data set that has multiple date columns, the date show when the task came in (created date) and when the task was completed (completed date).
I have created a dashboard that shows this data, however when I select Completed in the slicer at the top I would like the date slider and the date graph to change from "created date" to "completed date" , but keep the inputed dates, is this at all possible? all of this data is held in one table at the moment.
Hi, @Anonymous
I really want to help you, but I can’t understand what you said ‘keep the inputed dates’ and ‘change from "created date" to "completed date"’, isn’t this contradictory?
Could you mind share some sample data and your desired result? So we can help you soon.
Best Regards
Janey Guo
@Anonymous , You can create a date table and join all dates with that. Only one join will active. Use inactive join using userelationship.
https://www.youtube.com/watch?v=e6Y-l_JtCq4
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |