Date Comparison Chart

[bood11]

I want to create a comparison chart between two years using the same table of daily activities, and I want to show where each action occurred and how frequently it occurred during each given month.

below is an exampel:

I'm looking for support pls.

[v-chenwuz-msft · Accepted solution]

Hi @bood11 ,

Create a measure via count('table'[activity]) for chart's values.

I think you need a map visual to show where each action occurred.

Pbix file in the end.

Best Regards

Community Support Team _ chenwu zhu

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

[bood11]

Many thnaks for the valuable support 😍

[bood11]

@Greg_Deckler Thank you for your reply , Can you please tell which DAX should i use?

[Greg_Deckler]

@bood11 Use disconnected tables for your year slicers. Then you construct your measures so that you grab the selected year from the slicer and do your calculations accordingly.