End of Week Column messes up my visuals

[DaddyFresh87]

Hello everyone,

I have an issue where every time I try to use "end of week" in my date table to be able to drill down, it causes the visual to stop being overlapped. I have added pictures to try to help diagnose the problem.

None of my date heirarchies work properly, so I've come up with a work around, but I want the lines to layer over each other instead of having 2023, then 2024. 

Any help would be appreciated, I can provide more info if you need it.

Thank you!

 

[Anonymous · Accepted solution]

Hi, @DaddyFresh87 

For example, if you want 2023 and 2024 to be represented in two lines, try writing separate expressions for those two lines.

Measure2023 = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),YEAR([Date])=2023&&MONTH([Date])=SELECTEDVALUE('Date'[Date].[MonthNo])))

Measure2024 = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),YEAR([Date])=2024&&MONTH([Date])=SELECTEDVALUE('Date'[Date].[MonthNo])))

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DaddyFresh87]

Thank you for you assistance!