The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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.
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
94 | |
79 | |
65 | |
55 | |
52 |