Forum Discussion
MoM Sales Data by Choosing Month from Visualization
Resident RockstarHi sevens,
I 'm not very clear about your requirement, do you want to select one of the month in the a clustered column chart, then the Tornado graph will be filterd?
It's displaying a figure, but I'm not sure what it's calculating and it stays static. No matter what month I select at the top it doesn;t change. It's the darker color on the right.
Do you mean the output like this? This is the interaction between the visuals.
Besides, it seems that your measure formula should be right, if the date in PARALLELPERIOD function to be the Date[Datekey] will be better.
What is your desired output? Could you describe in more details?
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Thank you for the reply, Cherry! Here's what I'm looking for (and there may be a better way to go about it. I'm totally up for suggestions.)
When the pbix file loads, the clustered column will automatically filter to the current month. That, in turn, will automatically make the tornado chart filter to current month AND previous month sales. The darker color in my image represents the previous months sales. But like I said, the figure will not change no matter what month I select in the clustered column chart. It just stays the same. That measure is a custom calculation with the PARALLELPERIOD forumula I have in my original comment.
I think there's something missing from the formula. I'm having a hard time figuring out how I can pass the dynamic time period to it (the information that the user selects from the clustered column chart.) It's like it's not reading what month is being selected.
Hopefully this helps make more sense! Thanks again.