I’m reaching out to seek some guidance on a specific use case I’m currently working on.
I’ve been trying to create a drill-down action on a stacked area line chart, aiming to navigate to another sheet. However, after applying the action, it doesn’t seem to trigger any response in my stacked area line visual.
I’ve followed the usual steps for creating drill-down actions, but it seems like there might be a compatibility issue with the stacked area line chart. Has anyone else encountered a similar situation or successfully implemented a drill-down action on this type of visual?
Thank you for your response. I’ve generated a stacked area line chart by utilizing a date-calculated field on the X-axis and a measure field (agg: count distinct) in the Value. Currently, I’m interested in enabling users to select a date from the X-axis and after selection, they should be redirected to the next sheet, where they can observe a drill-down in a table specific to the chosen date from the X-axis.
I’ve attempted to apply a drill-down action to my stacked area line chart using the standard steps, as outlined in my initial message. Unfortunately, the action doesn’t seem to trigger. On the other hand, the same drill-down action works as expected on a stacked bar chart (after clicking on any bar I am navigated to the target sheet). Does this indicate that the stacked area line chart doesn’t support drill-down actions?
We have to differentiate here between drill down and drill through. drill down is in case you define a “hierarchy” in the visual and drill down by click or the down arrow on the upper right corner. drill through is an action (select or menu) where you jump to a different sheet/url.
You mentioned “should be redirected to the next sheet”. That will be a drill trought/action. You can add a paramater for the date to be handover to the next sheet.
Apologies for my mistake. You are correct; I am aiming to implement a drill-through feature. Currently, I have created a parameter of date type and utilized it to store the value of the calculated date field, intending to pass it to the next sheet. I was wondering if it’s possible to create a drill through function by clicking on the x-axis labels. However, seems that the drill through action from stacked area line chart is triggered from the graph itself, not from the labels.
Was @ErikG 's post helpful, and if so could you mark their comment as a solution?
It has been a few days since we have heard from you but would still like to help find a solution. If we do not hear back from you in 3 days this post will be archived.
