Hello,
I am having the following problem that I cannot solve.
I made a chart with bars and lines where the lines show the metric sales MoM that displays the month-over-month variation. Additionally, with a calendar table, I am using a slicer that filters by day to compare sales within a certain range of days.
Everything works perfectly, except for the following specific case that I cannot solve.
In the table I am uploading, the last recorded day is 5/5/23. If I filter to see the information for days 1 to 4, the metrics work perfectly. But if I filter to see the information for days greater than or equal to the last day recoded, it stops working (for example 1 to 5 or 1 to 8). Does anyone know what I can modify to make it work consistently?
I am uploading the Power BI file with the example and the metrics created:
https://drive.google.com/drive/folders/1SIBxFXl1CB3n0gnH2GM6CJe9044dHk_M?usp=share_link
Thank you very much in advance.
