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.
Hi all
I have two tables with different data. Both have a end of month Date field (although by different names).
I would like to plot data from the two tables on the same plot, with the x-axis using the same dates, how do I establish this relationship or let Power BI know that the two dates are the same and plots/data can be shared?
Solved! Go to Solution.
You can create the relationship by:
1. On the Home tab, click Manage Relationships > AutoDetect.
2. Create a relationship manually. draw a line from the date column in the first table to the second table:
Then create the visual using date as x-axis:
You can create the relationship by:
1. On the Home tab, click Manage Relationships > AutoDetect.
2. Create a relationship manually. draw a line from the date column in the first table to the second table:
Then create the visual using date as x-axis:
Create a relationship for the common column from Home >> Manage Relationships.
Now use the date column in X-axis and measures in Y-axis.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
70 |