1
votes

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

1

1 Answers

1
votes

a screenshot could help, but is the slicer based on the date in the calendar date or on the createdon date ? Maybe you should try to switch the column you use in your slicer.