Solved: Date on Slicer binded to each other?

Anonymous · ‎05-29-2022

I have StartDate and EndDate which boths start from 2022-01-01 and end on 2022-05-31.

I have both of them appear as Dropdown as shown:

But when I select the StartDate as 2022-01-03, why is the EndDate only has 22-01-03?

which portions went wrong that both StartDate and EndDate are binded to each other?

v-jayw-msft · ‎06-01-2022

Hi @Anonymous ,

That is because the Slicer size is too small.

You will need to increase the size of entire visual.

Best Regards,

Jay

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

Anonymous · ‎05-30-2022

other minor question is when I increase the font size, it does not have any difference. But color is OK.

v-jayw-msft · ‎06-01-2022

Hi @Anonymous ,

That is because the Slicer size is too small.

You will need to increase the size of entire visual.

Best Regards,

Jay

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

Anonymous · ‎05-30-2022

I have solved it, thanks all.

Anonymous · ‎05-30-2022

Ashish_Mathur · ‎05-30-2022

Hi,

Why do you want to create 2 slicers? Create a Calendar Table first and build the slicer from that table.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎05-30-2022

I have the same issue when link to one Date table for the StartDate and EndDate.

are we able to upload our .pbix file here? it seems not possible.

Anonymous · ‎05-30-2022

oh ya, I know what you mean, let me try out and let you know...

Anonymous · ‎05-30-2022

but I need to have 2 control for the StartDate and EndDate.

sturlaws · ‎05-30-2022

Hi,

I can't help you with this unless you share the report, or create a mockup report reproducing your issue and sharing that.

Cheers,
Sturla

Anonymous · ‎05-30-2022

how do I upload a .pbix file here?

Date on Slicer binded to each other?