Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🙂
@Leozin28 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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |