Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply

Date picker for Matrix table

Hey guys, 

I have been working on the single date picker for my table. So I just want 19/06/2021 instead of between 19/06/2021 and 15/09/2021. I used the slicer, it seems not working as respected. 

I also watched GuyInACube and a lot of research but I couldn't fix it out of the measure. 

 

Any help will be appreciate

Thank you so much
post.PNG

 

 

7 REPLIES 7
v-henryk-mstf
Community Support
Community Support

Hi @VictoriaNguyen ,

 

As @Greg_Deckler  said, by changing the type of slicer to list, you can select a single date. Then connect it to the calendar table, and display the selected date in the slicer on the calendar table. do you mean this.

 

Maybe you can also refer to the following video, I hope it will help you. If you are still confused, please point out.


Best Regards,
Henry

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-henryk-mstf 

Hey there, so I want only one date slicer with the calendar view.

Yes, I can use the calendar sample following the video that you sent but the calendar custom like that will take too much space on my report. 

 

Hi @VictoriaNguyen ,

 

What does taking up too much space specifically refer to? Memory or the effect of page display? But I think this might be the best way to present.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-henryk-mstf I mean about the page display. Because I have a report with display a lot of information. So I tried to find something like a calendar view with the limited page display.  

 

Thank you

Hey, @Greg_Deckler  Thank you so much for your solution.

Below the screenshot, we are seeing two dates start and end. Business needs only one single date slicer default to days dates slicer with calendar view. Business wants to open dates very quickly and easily. Can you please assist?

 

ssss.PNG

 

Sorry for my English if this makes you confused 

@VictoriaNguyen Not aware of a way to do that.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Community Champion
Community Champion

@VictoriaNguyen In your slicer visual there should be a little drop down arrow in the upper right corner when you hover over the visual. Click that and change the type of slicer to a list or dropdown or single select. 

 

If that is not it, I don't understand what you want.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.