Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a graph showing sales this year and sales last year. I want this to show results for 'this month' which I am able to do using Relative date filtering.
However, on the 1st of the month I still want to show last months results as the data is always 1 day behind.
When you choose relative date filtering "in the last" there is a tick box to exclude or 'Include today'. This tick box would solve my problem but it disapears when you chose 'is in this'.
Is there another way around this? I am aware of the 'Anchor date' option for Date.value slicers but it is not dynamic and ideally i dont want the user to have to use a slicer.
Hello @Anonymous
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.
You can send the sample .pbix file by adding it to your drive or dropbox and add the link here.
Regards
Kumail Raza
Hi, @Anonymous
Yes, there is a way to solve it, you can create a measure and put it in the filter pane to achieve the same effect. Can you share some sample data? So we can help you soon.
Best Regards
Janey guo
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |