Forum Discussion

bood11's avatar
bood11
Regular Visitor
4 years ago
Solved

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. ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

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.