Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Slicer

Hi I am not able to get the date slicer to work. I have one table called Quotes & another called Sales. I have created another table called Dates - which has unique dates. I have created many to one ...
Need Help
amitchandak's avatar
amitchandak
Super User
7 years ago

Do your date/s, in fact, have timestamp?

Can you share some screenshot dates(joining columns) by hiding sensitive information? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi so the Date field in table DImDate links to the Business_Event_DateTime fields in the Business_Confirmed & Business_Full_Quote tables. The Date slicer is based on the Date field in the DimDate table. When I move the slicer the Quote Count figures change but the Sales Count figures dont

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    [Insurer] is from Business_Confirmed or  Business_Full_Quote table?

    [Insurer] in two visuals are the same one or two different columns?

     

    As tested, if [Insurer] in two visuals are two different columns from two tables, then my Quote Count figures and Sales Count work well.

    If  [Insurer] in two visuals are the same one from one table, it doesn't work for Sales Count.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.