Customizing the order of fields in the hover over of visualizations

[Bahjat]

Hi team,

My work involves building dashboards that provide key insights to stakeholders. I am currently using the AI/BI dashboard functionality and seemed to have hit a limitation that I'm hoping someone can help me work around. 

One of the visualizations that I have is a scatter plot. I want to customize the order of metrics within the hover over such that a metric not on the X and Y axis is show first. It seems like it's not possible to do so at the moment as the X, Y, color always show up at the top with no ability to change their order with respect to other metrics in the tooltip.

Is that correct? Any ideas how I can work around this?

In the example below, I want item to come first

[szymon_dybczak]

Hi @Bahjat ,

Unfortunately, tooltip ordering does not currently appear to be configurable. Maybe try to suggest addition of that feature on Databricks Ideas portal.

[Ashwin_DSA · Accepted solution]

Hi @Bahjat,

As @szymon_dybczak has mentioned, there isn’t currently a way to reorder them so a field like Item appears at the top. As of now, AI/BI scatter plot tooltips show the x-axis, y-axis, and colour/grouping fields first by default. If you’d like to upvote that ask, here’s the public feature request: Custom ordering of tooltips. 

This may not be ideal, but a practical workaround is to add a small table next to the scatter plot with Item as the first column, and then use the scatter plot for selection/filtering. Cross-filtering works across visualisations that use the same dataset, so selecting a point in the scatter can update the nearby table. The docs for that pattern are here: Use dashboard filters.

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

[Bahjat]

Thanks both! appreciate the feedback.

[szymon_dybczak]

No problem 🙂