Is there a way to show just only 1 department instead of showing the other departments?

[Anonymous]

Hello everyone, i have 100,000 employees record in an excel file. However, i have created a sample of 10 employees record in order to generate the below chart. I would like to ask is there away to display only merchandising department when i click on the blue bar? Instead of showing the other departments in light blue? Thank you. 

[Anonymous]

Hi @Anonymous ,

For a single visual, the only interaction is "highlight".  You need to use a slicer or apply filters to "filter"

And there is a setting in Power BI to change interaction between visuals.

In Power BI desktop go to File->Options and settings->Options->CurrentFile->Report Settings->Change default visual interaction from cross highlighting to cross filtering option. Enable it and restart PBI, it should work fine.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973 · Accepted solution]

Hi @Anonymous 

You need to add a slicer for the departments and filter it there

[Anonymous]

Is there another alternative if i dont want to add a slicer? 

Thank you for the above response!