cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

AI BI Dashboard Table filtering

JZhang
New Contributor

Hello community of Databricks

I need some help over a specific issue in AI/BI Dashboard filtering

My current dashboard has 2 widgets:

- A map containing the shopID and it's current GPS location

- A table showing all the available shopID with some metadatas 

I was wondering if it is possible to click on a specific row of the table to filter the specific shop in the map, but right now it returns me "Unable to render visualization" when clicking on a specific row of the table.

The filter widget is available but i would not say it is the most intuitive way since i can't even copy the shopID from the table (the default is selecting a specific row)

Let me know if additional infos are required to solve my doubt! 

 

1 REPLY 1

iyashk-DB
Databricks Employee
Databricks Employee

Table widgets in AI/BI dashboards don't support cross-filtering, that's what's tripping you up. Click-to-filter currently only works for bar, box plot, heatmap, histogram, pie, scatter, and point map visualizations. A plain table isn't in that list, so whatever interaction you wired up on the table row is hitting something the widget type doesn't support, which lines up with the "Unable to render visualization" error you're seeing.

Since your map is a point map, that direction actually works the other way already: clicking a point on the map should be able to filter the table, if the table shares the same dataset as the map. Worth testing that first.

For row-to-map filtering, skip trying to make the table itself clickable and add a field filter widget on shopID instead:

  1. Add a filter widget to the dashboard and bind it to the shopID field.
  2. Attach that filter to both the table and the map widget.

That gives you a dropdown/search control that drives both widgets together, which is the supported pattern for this right now rather than expecting the table row click to act like a chart click.

On copying the shopID out of the table, I couldn't find anything in the docs about a built-in copy-cell action, and row click just selects the row as you've found. Your more reliable option is to use the widget's download/export option to pull the underlying data as CSV if you need to grab exact values, or lean on the field filter's search box from step 1 to look up a shopID instead of copying it out of the table.