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.
Hey, there I am looking to create a sing slicer that will slice two different date columns. I have data on jobs that come in which have a created date and a resolved date which are the main dates of interest. The resolved date is only populated when the task gets resolved.
I have created a dashboard that has multiple different graphs that each use the resolved or created date separately and would like to be able to select a single date e.g. the Month of January 2020 and filter the page to show this data.
Solved! Go to Solution.
@Anonymous , you need to join the tables with same date table. One join will be inactive. You can use userelation to activate the join.
refer to my blog on similar topic : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
@Anonymous , you need to join the tables with same date table. One join will be inactive. You can use userelation to activate the join.
refer to my blog on similar topic : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Hi thanks for the quick reply. I tried that and it messes up the dashboard.
I created a date table using the following code
However it messes with the dashboard and breaks a lot of it. Is there any other alternatives or ways around this? It breaks the dashboard even when they are both inactive.
Hi , @Anonymous
Once you create an inactive relationship, it means that when you want to use the inactive relationship to filter any field in the visualization, you need to create a new measure to replace it (see measue "End date2" in pbix file) .
Here is a sample file.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |