dublicated date entries in slicer

[Pikachu-Power]

hello all,

i have datetime column and change it to date. when i use it in a slicer i see:

Monday 25.04.2022

Monday 25.04.2022

Monday 25.04.2022

three times the same date. It is because there are three different times following. How can i adjust that so that i see just one choice in the slicer?

thanks.

[SpartaBI · Accepted solution]

You need to change it in Power Query or in the data source. Change it in the model (data type / format) will keep the knowledge of the time in the cell even if you don't see it, so it's actually 3 differnet values

[Pikachu-Power]

Okay that should it be 🙂 I created a new column with DATE(YEAR, MONTH, DAY). That also helped.

[SpartaBI]

Sounds good 🙂
In case you also need the knowlegde of the time in your model, that's what you need to do. Even better to only keep the time in the datatime column to decrease it's cardinality and improve the size and performace. In case you don't care about the time than better of course to remove it before and not create another column, casue now you will have a redundent column with the time (which is actually a heavy cloumn becasue of it's granularity).
Any way, if we ae talking about small models, non of this really matters in practical 🙂

[SpartaBI]

Where did you change it to date? In the format / date type in model / Power Query?