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.
Hello,
I am currently working on creating a report that requires pulling data from two different workbooks. Each colum has the same type of data, just dates. So when creating the report. I have two seperate Y-Axis from each workbook but it only works from which ever one is listed first.
So here are the two Y-Axis, I need to somehow combine them. If I switch the order, it makes two differnt reports and numbers are only right half the time.
Please help. Thank you!
Solved! Go to Solution.
Hi @michaelcalm ,
You can try creating a calendar table, connecting it with your two tables, and then adding the quarter field from the calendar to the y-axis of the visual.
In this case, you can use a quarter field to display the data from both tables.
I made a simple sample file for your reference. Please download and check.
In this sample file, I also create a separate table as a slicer field selection.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @michaelcalm ,
You can try creating a calendar table, connecting it with your two tables, and then adding the quarter field from the calendar to the y-axis of the visual.
In this case, you can use a quarter field to display the data from both tables.
I made a simple sample file for your reference. Please download and check.
In this sample file, I also create a separate table as a slicer field selection.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@michaelcalm , based on what I got you need to create common tables
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |