Forum Discussion
Date Range Text Box When No Transactions
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
3 Replies
Try this
yourheading = MIN('Calendar'[Date]) & " to " & MAX('Calendar'[Date])Please click the [accept solution] and thumbs up buttons, thank you
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:
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
