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
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
7 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.