I have a bar chart in one sheet and I want that when you click on one bar, you are redirected to another sheet where a table showing info filtered by the values on the bar selected on the bar chart is displayed.
Is it possible to use the action filter within different sheets? If not how can I approach this task?
Hi @01267ts,
Yes, you can do this by using a navigation action. The target sheet is where your user will be redirected to. You can pass values to parameters with the action. You then need to link those parameters to the filters on your target sheet.
Hi @01267ts
Welcome to the QuickSIght community!
-
You can create a Navigation Action in your Source Sheet’s visual
-
In the action you can map the field values to Parameters that you can use in the Target sheet
-
Click on the + button against the Parametes to show the following dialogue where you can do the mapping.
-
I mapped the SKill Name field to Locations parameter (I keep experimenting…don’t mind the illogical parameter name!)
-
In your Target sheet you can filter the visual using the parameter
-
So if I click on Blogging Skill you navigate to Target Sheet and the table visual filters to only show Blogging related rows
Hope this helps.
Regards,
Giri
Thank you very much. I have managed to do it. It was very useful for me!