Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two distinct data sets that each contain a date field along with separate number values for each date.
Instead of having one date slicer for each data source I would like to have one that controls both graphs at the same time.
How do I link the two date fileds together?
Solved! Go to Solution.
You can add a Date table to your model and make a relationship to each table to one of the date columns. You can then make a single slicer from a column in your Date table and use the Date columns in your charts to get your result.
Creating a simple date table in DAX - SQLBI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
That did it, thanks
You can add a Date table to your model and make a relationship to each table to one of the date columns. You can then make a single slicer from a column in your Date table and use the Date columns in your charts to get your result.
Creating a simple date table in DAX - SQLBI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
93 | |
84 | |
69 |