Forum Discussion
undefined
I have two spreadsheets 2018 data 2019 data When I create a clustered column chart to compare YOY by month, I run into a few issues. Fields are populated as follows: Axis 2018 Date o...
You're going to need to combine the two sets of data somehow - either merge the queries, or create some sort of linking table listing the months. Right now I'm guessing they are separated and you just have a list of months on the 2018 table, Power BI's not going to know which of those months the 2019 data applies to so it does it for all of them
Do you know how to create a linking table listing the months?