Using Filters via KPI visuals

[Derek_Sanborn]

Hi,

I have 4 or 5 KPIs visuals at the top of my dashboard. These KPIs each have their own filters. I want users to click on these KPIs and pass through the filters. The action filter is not working because there is no “value” on the KPI. Any ideas?

Here is a video I made: Quicksight - KPI filters | Loom

[DylanM]

Hello @Derek_Sanborn, welcome to the QuickSight community!

I seriously appreciate you sharing the video as part of your explanation, it made it a lot easier to understand what you are wanting to accomplish.

Unfortunately, there isn’t enough data/columns stored in the KPI to build an action from it that could filter your visuals how you are wanting. The alternative solution for something like this would be to create buttons with table visuals that could run the action for you.

You could create a button for each KPI that you want a filter for, add all of the necessary fields required for filtering, then hide the headers and all columns besides one. You can leave a calculated field that returns a simple string like “Filter for On Hold” and format the cell to look like a button. I’ll link an example for creating a button from a previous community response.

Using buttons to navigate the sheets

Hi Team, Is there a way we can add buttons that navigate to different sheets within our dashboard? I want to create a Daily, Weekly and Monthly view for the cost incurred to the org. I want to provide the user an ability to toggle between these sheets to switch from daily to weekly to monthly view, order not necessary. I looked at a couple of similar questions on the forum but none of them have clear responses. I want to use the navigation action using a button or a link on one of the sheets …

Let me know if this helps!

[Xclipse]

Hi @Derek_Sanborn, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

[Derek_Sanborn]

Hey guys, I just saw this response. Let me give it a try and see if that would work. I’ve been a bit swamped with some other projects but will get to this over this weekend.