Forum Discussion
Slicer does not work when merge queries.
Anonymous It sounds to me like maybe you don't have a common date table in your model? If that's the case I would highly recommend using one.
That would allow you to relate both table A and B to the common date table with one-to-many relationships, and then use the Month from the date table for filtering both tables.
https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
Hi Anonymous can you help me with this? https://community.powerbi.com/t5/Desktop/How-to-generate-text-value-to-another-table/m-p/1578665#M641674
Anonymous I'm taking a look at the .pbix that you shared in that thread and to be honest your model isn't making a whole lot of sense to me.
If your "by well" table (which I'm assuming is the "Table A" you're referring to) doesn't contain data at the Month granularity (only by Year), what exactly are you expecting to happen when you filter it by a Month?