How to combine two Y-Axis from different workbooks in a stacked bar graph

[michaelcalm]

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! 

[v-stephen-msft · Accepted 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.

[amitchandak]

@michaelcalm , based on what I got you need to create common tables

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...