2 slicers into 1

[Anonymous]

Hey guys, hope u all are fine!

I come here with a simple question, but I couldn´t find it anywhere in this site nor ytb videos.

Can I merge 2 pannels (slicers) into 1? They are being fed with different data (excel files), but the slicer pre-selection is the same in both. 

Example: (sorry for the portuguese, I'm brazilian)

 

On slicer 1, I can select between 2 companies: Gestora and Distribuição. After that, I choose an especific characteristic on slicers 2 or 3. However, slicer 2 only works with "Gestora", while "Distribuição" only impacts slicer 3 (second print screen).

Is there a way to, IN THE SAME slicer, merge slicer 2 and 3?

And based on my company, the slicer will instantly filters and shows the information for this selection, without showing the temporary useless slicer content (let´s pretend that I chose "Gestora" at the beggining, this new-merged slicer will not show info from slicer 3).

Ty in advance! 🙂

[Greg_Deckler]

@Anonymous So I would think the way to do this would be to create a table like this:

Company, Type, Value

Gestora, Category, Fee Fixo

Gestora, Category, Fundos de Investimento

Distribuição, Asset, BM&F

etc.