The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I am working with "Decomposition Tree". I know that if I click on another visual that the decomposition tree is automatically filtered. But I don´t know how to filter a table or another visual by clicking on decomposition tree branch.
Is it possible?
Thanks in advance
Solved! Go to Solution.
yes, it seems like filtering to other visual doesn work if you choose not the last level of Tree. Bet, if you click on Resolution, your matrix will be filtered
Hi @Ley ,
Based on my test, I cannot reproduce your issue here. Please set the relationship to both instead of single.
I have the same issue. The Decomposition tree is a chain of filters (first filter on x, then, y, then z), but cross filtering doesn't preserve this filter chain, it just filters other vizualizations by a single selected dimension.
For example, if you had an organization made of of Employees and Contractors working in Departments and you wanted to cross filter some table to show employee details.
#Employees -> Employee
-> Contractor -> Department 1
- > Department 2
Clicking on Department 1 will corss filter other vizualizations by "Department 1" but not by "Contractor" & "Department 1".
This isn't expected behavor.
All relationships are correctly created , but it does not work.
On the Tree Format, is the default action set to "Filter / highlight"? If not, give it a try.
Hi @Ley ,
Based on my test, I cannot reproduce your issue here. Please set the relationship to both instead of single.
Hello, could you please let me know what do you mean by "Bet, if you click on Resolution, your matrix will be filtered"? Thank you.
User | Count |
---|---|
69 | |
64 | |
62 | |
55 | |
28 |
User | Count |
---|---|
203 | |
82 | |
65 | |
48 | |
38 |