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
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 😍
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?
