I need some help with building visual interactions on my dashboard. I have attached a snapshot of my dashboard here. what I am looking for is - When I click on the 'Amber' column in 'Projects by RAG status' visual, all the other visuals get filtered. Now, keeping the Projects by RAG Status filtered at 'Amber', I would like to filter down to the column 'Under $5 million' in the second visual titled 'Projects by Actual Cost'. Is this something that I can build into Power BI? All the data comes from a single table, in case that helps.
I am not sure if it's possible, as far as I know if u activate the "Drilling filter others visuals" option you can filter all columns from the others visual.