Forum Discussion

bearcatrunner's avatar
bearcatrunner
New Member
4 months ago
Solved

Events Dashboard

I'm creating a dashboard where I can choose a single store and have a bar chart by stores by period by year.  I've got that part to work but I also want to include events that might have affected the...
Need Help
  • mickey64's avatar
    mickey64
    4 months ago

    For your reference.

     

    Step 0: I use these data below.

    <Calendar>

     

    <Sales>

    <Events>

     

    Step 1: I add two relationships below.

     

    Step 2: I make two measures below.

        Heavy Snowfall = SUMX(FILTER('Events','Events'[Event]="Heavy Snowfall"),'Events'[Flag])
        Tornade = SUMX(FILTER('Events','Events'[Event]="Tornade"),'Events'[Flag])

     

    Step 3: I make a graph below.

     

     

     

Natarajan_M's avatar
Natarajan_M
Super User
4 months ago

Hi bearcatrunner , Could you please share the sample data in a pbix file so the community can help you better ?

thanks