I am having a powerbi report for leads/opportunities of dynamics 365.
I created a new date table and added a column to it as Calendar('1/1/2021','31/12,2021)
the table is created successfully then i am marking this table as date table then i am creating a relationship between the column in the newly created table and the createdon table inside the leads then i am adding a slicer control on the report to filter the leads by the date
but the filteration is not working fine as soon as i move the slicer, all the leads get hidden.
any ideas why that is not working??
Thanks