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.
Hello,
I would like to create a text box to add a title for my report which includes the dates applied in the date filter.
The title would look like "Results between XX/XX/XXXX and XX/XX/XXXX"
Thank you for your help
Pauline
Solved! Go to Solution.
Hi, @Anonymous
Please try to write the below DAX measure for your title.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
According to your description, I think you can create a measure and set the text box title as the value of the measure to achieve this, you can try my steps:
Title =
var _min=MINX(ALLSELECTED('Date'),[Date])
var _max=MAXX(ALLSELECTED('Date'),[Date])
return
"Results between "&_min&" and "&_max
And add a date slicer to your page, then you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you able to re-attach the link to the pbi as i would like to view how you have done this..
Hi,
Sorry, my OneDrive account has been expired and the pbix file has been deleted.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-robertq-msft and @Jihwan_Kim
It works but it's a shame that we have to create a measure for each chart title if we want it to be different.
Have a nice day
Hi, @Anonymous
According to your description, I think you can create a measure and set the text box title as the value of the measure to achieve this, you can try my steps:
Title =
var _min=MINX(ALLSELECTED('Date'),[Date])
var _max=MAXX(ALLSELECTED('Date'),[Date])
return
"Results between "&_min&" and "&_max
And add a date slicer to your page, then you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Please try to write the below DAX measure for your title.
Jihwan Kim
If this post helps, then please consider accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |