Forum Discussion
WeekOfYear showing data from multiple years
lbendlin - I thought instead of leaving your comment with no response, I would advise that I did not have time to supply you with the data - my apologies again if that offended you.
However, I did work out the solution with the asssist from Copilot.
For future reference and if anyone else gets this form of error within their own report -
All I had to do was dropALL('Calendar')from my measure. As this was resulting in the filter to view the entire dataset across all dates, and not just the ones currently being looked at.
First of all you will have to define what you mean by "current year". If you want this to be deterministic then you have to add the year to your visual, ideally in the same area as the week, just above it in the hierarchy. Or you have to add a Year_Week column to your calendar table and use that instead.
Thanks for the response lbendlin - Current year in my view would be the year selected in my slicer...
So I have tried adding in the year to my table visual and still receive the error. Then I have tried with the new "YearWeek" column -
YearWeek = FORMAT('Calendar'[Year], "0000") & FORMAT('Calendar'[WeekOfYear], "00")
However still the same error I am facing.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523