Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, i am doing a report with data from Excel.
The problem i see is that i have a report with number of trips, which despite i use ISO-Week, does not include sunday, when i run it today.
For example, week 5/2022 consists of only 6 days, not the 06-02-2022.
The data for 06-02-2022 is avaliable, and when i create a new slide the 06-02-2022 is included in Week 5.
I have checked all filters, and copied the matrix table 1:1 in a new slide, and there again, in the new report, the 06-02-2022 is not missing.
Last week i had the same problem with Week 4 with missing last day of week, but now Week 4 is correct, and Week 5 is the problem....
What could be the problem, if it is not the filter?
W
Solved! Go to Solution.
Hi Amit, i finally found it, there was a hidden slicer with the last 52 weeks activated, these weeks are not ISO compatible.
@bilingual , How you have created ISO week ?
like ?
weeknum([date],21)
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit, i finally found it, there was a hidden slicer with the last 52 weeks activated, these weeks are not ISO compatible.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |