clustered column chart with two data source, why date slicer not working well for one data source?

[JACKZHAO]

Hi: Community

I am new to the power bi desktop, now I creat one clustered column chart with two data source, why the date slicer not working right for one of the data source? looking forward your reply and support.

[johnbasha33]

Hi @JACKZHAO  first of all your model needs to be changed with proper cardinality. make sure you are joining with right columns from both tables. any unique ID from the both tablesa like a primary key. for example, Product ID or ID. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[JACKZHAO · Accepted solution]

Hi:

I tried many ways, now the issue looks covered.

[JACKZHAO]

In my table, the data source is share point list, the ID generated automatically, so, the ID can not be taken for relationship, right?(I tried, not working).

when I create the relation ship before, I encountered the "many to many" warning, so, I create another date table, added it into the slicer, but the same issue, one chart no relecting by the date slicer