Drill Down from one visual to the other

[mkadavil]

Hi folks,

I am trying to create a report from SSAS MDX Cube. I have created a bar chart with the values breaked down per month.

I want to be able to click on a month and then able to change a visual on another chart that is corresponding to the month selection. (Until this, it is possible)

Now from this visual, keeping the month filter in place, i want to make selection and then show a visual on another chart.

 How is that possible? For those you have worked on Spotfire, i am looking for something like "Create Details Visualization".

Please help! 

[molegris]

Hi,

I see that this post is from 2018.  I was wondering if the Drill through option it still the only workaround available?  It would be so much better if visual-filters could be persistent until you click on it again.

--mo

[v-yuezhe-msft · Accepted solution]

@mkadavil,

You can use Drill through feature to achieve the above requirement.

The third chart also be affected by the selected month in first chart, right? If so, put the second chart and third chart in a report page(Page 2), which is different from the report page(Page 1)that first chart resides in. Then drag the YearMonth field to Drillthrough filters of Page 2.

This way, you can right click on the Month in first chart, and select Drillthrough->Page 2, then click on the data point in second chart, the third chart will be filtered accordingly.


Regards,
Lydia

[mkadavil]

Thank you @v-yuezhe-msft!

Mid