Hi,
I need to show data in a report for only one month. Please let me know how to set the date in the report.
Thanks.
Solved! Go to Solution.
@sshiny Multiple ways to do this. One of them is to add a page filter on Date and set it to this month.
or you can filter the data in a power query.
@sshiny Multiple ways to do this. One of them is to add a page filter on Date and set it to this month.
or you can filter the data in a power query.
Add a filter visual on your report page. Add the date field in there. I personally use the hierarchy of that date.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
75 | |
72 | |
48 | |
47 |
User | Count |
---|---|
160 | |
85 | |
80 | |
68 | |
67 |