Forum Discussion

Cbishop's avatar
Cbishop
Frequent Visitor
5 years ago

Chiclet slicer

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

Need Help

1 Reply

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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