Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have used the dax formula written here for a dynamic title, based on the selection of a filter. In my case, I am using week numbers instead of days of the week, and have therefore amended the dax as such.
It is working, however my issue is that when multiple week numbers are selected, they are not in any numerical order. As an example, when I select weeks 10, 11, 12 it displays as "Report Data for Weeks 11, 10 and 12". I've tried adding in sorting within TOPN, but all it does is interfere with the lastselected value delimiter, so it then appears as "11, 10, 12 and".
Hi @Sh4dow85
The Title2 measure looks OK. Based on my test, it works well as below. I have attached my sample file at bottom.
In addition, what is the data type of "Week_No" column? I recommend that you change it to Whole number type. This will make it be sorted correctly.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you for looking at this for me - I can confirm that week_no is already classified as Whole Number. This is how it's written, and the result I'm getting.
I have also tried
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |