I have a bar chart on the overview page in Amazon QuickSight, which displays revenue for 15 different sectors. Additionally, I have created 15 separate sheets, one for each sector.
Goal:
I want to enable navigation from the bar chart, such that clicking on each bar redirects users to the corresponding sector’s sheet.
Challenge:
Amazon QuickSight currently supports only one navigation action per visual, which means I can’t directly assign different navigation actions to each bar in the same chart. To address this limitation, I created parameters for each sector as action names and added menu option actions (Navigation Actions) to the bar chart. However, QuickSight allows a maximum of 10 menu options per visual, and I need 15.
Is there a way to increase the limit of menu option actions beyond 10 in QuickSight?
If not, are there alternative approaches or workarounds to achieve navigation to 15 different sheets from a single bar chart?
Looking forward to any advice or solutions that could help overcome this limitation. Thank you!
Do the 15 sheets have different visualizations or are they sourced from different datasets? You could map the values of the fields in the Bar Chart to a parameter.
So, if your visuals on the Sector sheets are all similar you only need to deal with how to map the value from the Bar Chart to parameter. But I don’t know enough about your requirement, hence want that clarification
All 15 sheets have distinct visualizations, though they are not sourced from different datasets. Since the visuals on the 15 Sector sheets are different, my main objective is simply to navigate to these sheets via the Bar Chart. I’m unsure how to achieve navigation to all 15 sheets using the parameter-based approach you mentioned earlier. Could you please elaborate or suggest a solution?
The 10 sheet limitation for Navigation means there is no benefit from field mapping to parameter. You will not be able to achiveve your 15 sheet requirement.
There is a free form layout where you can hide visuals dynamically. May be a mix of 9 sheets and one free form layout sheet where your 5-6 sectors are overlapping to make it work?
Thank you for suggesting the free-form layout. Unfortunately, we cannot implement it with a mix of 9 sheets and one free-form layout sheet overlapping, as it doesn’t meet the project requirements.
Could you please guide me on how to raise a feature request to address this QuickSight limitation of a maximum of 10 menu options and only One navigation action per visual
Having these features updated would significantly optimize the reports and enable smoother transitions between sheets, greatly enhancing the user experience.
Hello @Shreyas, while the exact functionality you are looking for is not possible, I can at least provide 2 work-around solutions utilizing the URL actions.
If the highest priority is keeping the visual in a bar chart, we can create the functionality, but the visual display will be a little odd. Create a calculated field that that returns the sheet id correlating to each sector value that exists in your dataset. The sheet id can be found when clicking between each sheet in the dashboard, it is the last id value shown after /sheets/ in the URL. Alternatively, you can return the entire URL excluding the https:// since that needs to be in the URL action text box. Now, to actually use it in the navigation action, you will be required to replace your Y-axis value for sector with the URL or sheet id calculated field. Since they are not values that will make sense to your user, you can hide the Y-Axis values from view and include the sector value in the tooltip. Again, this is not perfect, but then you can actually include the calculated field in the URL action.
Alternatively, and the easier option to implement, would be to switch to a table visual. This way, you can still show all of the values how you are wanting, but you can include the calculated field in the visual and hide it. That allows it to be referenceable by the URL action without it disruption the display of the visual.
I will also tag this topic as a feature request to increase the number of allowed actions per visual. Please let me know if you have any further questions about the work-around options I suggested, otherwise I can archive this for our support team. Thank you!
Hi @DylanM !
Thank you for providing your solutions earlier. I tried utilizing URL actions after creating the calculated field and passing the Sheet IDs on the Y-axis. However, as you mentioned, the visuals displayed looked odd and did not meet the project requirements, so I had to drop that approach.
In the meantime, I’ve found a temporary solution. I created visuals on the Free Form Sheet and used text boxes to explicitly pass the URL links. Below, you can find a snippet of my report showcasing how I implemented this workaround.
While working on this, I encountered a limitation: there isn’t an option to enable actions for text fields. If this feature were available, it would provide a much more efficient and smoother transition when navigating within the report compared to URL actions, which often experience delays when accessing the links.
Could you please review my feature request and advise if there’s a more efficient way to achieve this functionality?
Hello @Shreyas, I can definitely tag this topic as a feature request for our support team. The only alternative work-around solution I can really think of would be to utilize a table visual rather than the textboxes. That would allow for you to set up the URL or navigation actions rather than passing the links directly in the text boxes. Otherwise, this looks like a solid alternative solution. Thank you for following up!
