Chiclet slicer

[Cbishop]

I have created 2 chiclet slicers within my report 

When I select a month/combination of months and the POD Outpatient Attendances it works fine:-

However, when I select any of the other POD options (daycase/elective/outpatient procedures) on their own I lose the month options in slicer above:-

I have been through all the relationships on all the tables and everything looks correct.

Any thoughts/ideas as to why this is happening would be much appreciated.

thanks

Craig

[v-deddai1-msft]

Hi @Cbishop ,

What the relationship between the  date table holds month column and the fact table holds POD column? There should be a one to many and single direction relationship from date table to fact table.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai