My SALES LY and SALES TY vs LY

Hi all,

Tried this practice in the learning summit on customer Insights . But my SALES LY and
SALES TY vs LY still show the same value.

How do I resolve this .

Screen shot attached of both of my expected outcome and then the challenge

Hello @chukoz71,

Thank You for posting your query onto the Forum.

The reason why it might be showing the same numbers is because you don’t have any date context into the table i.e. any date field or don’t have any date slicer onto the page. Once you insert the date context either directly into the table visual i.e. in terms of date or if you put the date slicer onto the page and make selections into it you will see that numbers will start to differ.

Below is the example showcased where when nothing is selected numbers are same.

But now, when we make selection into the slicer the numbers will start to change. Below is the screenshot provided for the reference -

I’m also attaching the working of the PBIX file as well for the reference.

Hoping you find this helpful. :slightly_smiling_face:

Note: If this doesn’t solves your query than we request you to please upload the working of the PBIX file so that members of the forum can assist you in a better and efficient manner.

Thanks and Warm Regards,
Harsh

Date Context - Harsh.pbix (650.9 KB)

@Harsh

Thank you so much… it worked …

I appreciate the support here

Regards

Hello @chukoz71,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh