Forum Discussion
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 sales for that store. So I created an events table but I want the events to be labeled at the top. Something that looks like this rough drawing I made here. I would love any examples or how I can make this happen. Obviously I want the event to line up with the period and year better than below and maybe needs to go in the other direction.
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.
4 Replies
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.
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
HI @bearcatrunner, bearcatrunner
I am not seeing an attachment????Hi bearcatrunner , Could you please share the sample data in a pbix file so the community can help you better ?
thanks
