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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vutruong
Helper I
Helper I

How to set up Date-format Slicer without day time

Hi,

 

I want to apply my date-format data to appear only month-yy (Nov-2017). However I can not make it done with the Slicer chart.

 

1/ In the "Between" section in Slicer chart setup, its default includes dd/mm/year which show in the picture bebow, no option for mm/year only, though I set my data as month-year (November-2017

2/ Regarding data formating, there is no option for me to choose date format as Nov-2017, the simplest is the option November-2017 which I chose above. 

 

Is there any ways to complete two of my needs above? 

1.JPG

 

Thank your for your support.

 

Regards,

Vu

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@vutruong

 

1. For build-in relative date slicer, it must apply date range as filter. For your requirement, you may try custom visual like Timeline Slicer

 

2. For data formating, there's not build-in format like "Nov-2017". You may try adding calculated column in your source table and populate that column into slicer. 

 

Regards,

View solution in original post

1 REPLY 1
v-sihou-msft
Employee
Employee

@vutruong

 

1. For build-in relative date slicer, it must apply date range as filter. For your requirement, you may try custom visual like Timeline Slicer

 

2. For data formating, there's not build-in format like "Nov-2017". You may try adding calculated column in your source table and populate that column into slicer. 

 

Regards,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.