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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
icdns
Post Patron
Post Patron

Creating a dynamic year using text box

Hello, 

 

I would like to ask for your help, i am trying to display a dynamic note in my dashboard that changes depending on the filters selected. However, it is not in order. How can I sort this by year (eg. 2018, 2019, 2020...etc) ? By the way I am using below technique in displaying the note. I am just using a text box for this. 

 

 

icdns_2-1683523850216.png

 

 

Filters: 

icdns_1-1683523772063.png

 

Note in the dashboard:

icdns_0-1683523689283.png

 

1 REPLY 1
amitchandak
Super User
Super User

@icdns , Create a measure like


Measure 4 = CONCATENATEX(DISTINCT('Date'[Year]), 'Date'[Year],",",'Date'[Year])

 

and use that in text box

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.