Forum Discussion
Date Comparison Chart
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.
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.
4 Replies
- v-chenwuz-msft
Community Support
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.
Many thnaks for the valuable support 😍
- Greg_Deckler
Community Champion
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.
Greg_Deckler Thank you for your reply , Can you please tell which DAX should i use?
