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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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_
Super User
Super User

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_
Super User
Super User

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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