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 September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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