Forum Discussion
Helper IIILast Week comparison not working properly
Helper IIII understood the problem, unable to fix it
The problem is that, if the date selection ranges between weekly published dates, then it calculates the numbers correctly, but we selected the beyond that publish date, then it won works
Example,
I have the publish dates till 30th Jun 2021, in the date slicer, if i will select 7th Jul (greater than publish date), then it won't work because there was no values in that date range. So, how can i elimate the user to select the beyond the publish dates.
Community SupportHi, vijayvizzu
If you are talking about date slicer, then you can directly control the range of date selection on the filterpane to meet your needs.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
- vijayvizzu
Thanks for the suggestion, but how it can be dynamic ? I want to filter publish dated for a particular Source only, i have multiple sources in my main table.
- v-janeyg-msft
Hi, vijayvizzu (I took a long vacation due to illness)
I don't know your specific thoughts, but it should be possible.
You can create a measure and use it in filter pane to filter date dynamically like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,Community Support Team _ Janey