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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Automat year selection in slicer

Hi,

 

how can i selecet latest 3 years / Months / Date automatically in the slicer?

 

5 REPLIES 5
Gengar
Resolver I
Resolver I

Hi @Anonymous ,

 

Maybe you can create a flag measure to help

filter your data.

For example: create a meaure to calculate the date,if it is in the range, then return 1.

After you create the measure then apply

it to the visual level filter.


Hope this could help you!

Ganger

Anonymous
Not applicable

Hi,

Thanks for the response, However, sadly it does not make solution to my problem.
I want to select 3 latest financial year automatically.


Please check the below snip and suggest something.

Rohini_dubey_2-1668414838761.png

 





 

Gengar
Resolver I
Resolver I

You can click here to change the type of your slicer:

Gengar_0-1667833002250.png

 

Anonymous
Not applicable

I am just getting Dropworn and list option only, now what a suppose to do?

Gengar
Resolver I
Resolver I

Hi @Anonymous ,

 

You can use this! This is Relative Date slicer

Gengar_0-1667832860622.png

 

Gengar

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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