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.

     

     

     

mickey64's avatar
mickey64
Super User
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.

 

 

 

v-menakakota's avatar
v-menakakota
Community Support
4 months ago

Hi bearcatrunner ,
Thanks for reaching out to the Microsoft fabric community forum. 


I would also take a moment to thank mickey64   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team