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:ย 

Databricks AI/BI Dashboard cross-filtering across different dataset

lennox1
New Contributor II

Hello Everyone,

I recently started using AI/BI dashboard and I'm finding it difficult to cross-filter two visuals from two different dataset. Visual 1 displays Sales by region (month to date) sourced from dataset 1 and Visual 2 displays Open orders by region (month to date) sourced from dataset 2. Is there a way when I select South region on visual 1, visual 2 also only displays information for South region?

1 REPLY 1

BS_THE_ANALYST
Esteemed Contributor II

@lennox1 I've just gave this a try and didn't have much luck for cross-filter across multiple datasets. The documentation seems to indicate the same thing: https://learn.microsoft.com/en-us/azure/databricks/dashboards/#cross-filter 

I scanned the release notes for 2024 and 2025 with CTRL+F. There's a good deal of updates for cross-filtering. Could be worth keeping your eye out: https://learn.microsoft.com/en-us/azure/databricks/ai-bi/release-notes/2025 

To filter different datasets together, you could use a Global filter? โ˜บ๏ธ. I appreciate it's not quite cross-filtering but it's a cool thing nevertheless. I.e.

Before filter

BS_THE_ANALYST_0-1758052348580.png

After global filter

BS_THE_ANALYST_1-1758052410464.png


Some other community members may have some funky workarounds. 

All the best,
BS


Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now