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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
UditJ
Helper III
Helper III

How to create a Date Toggle ?

I would like to create a slicer/parameter with three categories - Day , Month and Year and based on selecting any one category the report/visual changes. The below image has an axis of month as by default the month category is selected. Similairy by selecting the day and year the axis needs to be changed. 

UditJ_0-1668001242145.png

 

1 ACCEPTED SOLUTION
onurbmiguel_
Power Participant
Power Participant

Hello UditJ

My suggestion is that you use Fields Parameters. 

Take a look at this exmaple: 

https://www.sqlbi.com/articles/fields-parameters-in-power-bi/

 

On your case you will choose year / month / day as parameters. 

 

Best regards

Bruno Costa | Continued Contributor

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

 

wp-1586527108426

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


View solution in original post

2 REPLIES 2
JoaoMarcelino
Responsive Resident
Responsive Resident

I agree with @onurbmiguel_ , Field parameters revolutionized our life.
We can either use it with fields (columns) from tables or even measures.
What a blessing from Power BI 🙂

Hope I was of assistance!
Cheers
Joao Marcelino

onurbmiguel_
Power Participant
Power Participant

Hello UditJ

My suggestion is that you use Fields Parameters. 

Take a look at this exmaple: 

https://www.sqlbi.com/articles/fields-parameters-in-power-bi/

 

On your case you will choose year / month / day as parameters. 

 

Best regards

Bruno Costa | Continued Contributor

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

 

wp-1586527108426

 

 


Best regards


Bruno Costa | Super User


 


Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 


Take a look at the blog: PBI Portugal 


 


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors