Date Range Text Box When No Transactions

[NMC20]

I have managed to make a Report Date Range text box on my report using Values in a text box. However, because I am calculating on the date in [Transactions] table, it only brings back the days where orders have been placed when I would like it to show the specific range I've selected in the filter, even if there are no transactions that day. 

I have a disconnected Calendar table for another visual within my report so I've tried using this date but then it brings back the earliest date of any Transaction in my data, ignoring any filter I have put on in relation to location. I don't really want a connected Calendar table because that appears to mess with my cumulative measures when I do that, for some reason... 

Is there a way I can create a text box that will replicate exactly what I've selected in the filters in terms of date range? 

Thanks in advance

[Anonymous]

Hi @NMC20 

Has your problem been resolved? If so, could you mark the corresponding reply as the solution so that others with similar issues can benefit from it?

Best Regards,

Jayleny

[Ritaf1983]

Hi @NMC20 

Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to

How to provide sample data in the Power BI Forum

If possible, upload a simplified .pbix file using this guide:

 How to upload PBI in Community

[speedramps]

Try this

yourheading = 
MIN('Calendar'[Date]) 
& " to " &
MAX('Calendar'[Date]) 

Please click the [accept solution] and thumbs up buttons, thank you