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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.