Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to filter data from two columns? For example:
C1 | C2 | C3 | C4 |
A | A | oher data | |
B | C | ||
C | E | ||
D | F |
I want to have a filter slicer with all the possible values within C1 & C2 to filter, if E is selected as the filter, so if I select C I shoud get row 2 and 3?
Solved! Go to Solution.
It is possible, by creating a disconnected table for your slicer and a measure. See attached, Page 8, Table14 and Table 4.
Table 4 = VAR __table = SELECTCOLUMNS(ALL('Table14'[C1]),"Value",[C1]) VAR __table1 = SELECTCOLUMNS(ALL('Table14'[C2]),"Value",[C2]) VAR __table2 = UNION(__table,__table1) RETURN DISTINCT(__table2) Measure 13 = VAR __value = MAX('Table 4'[Value]) VAR __c1 = MAX([C1]) VAR __c2 = MAX([C2]) RETURN IF(__c1 = __value || __c2 = __value,1,0)
It is possible, by creating a disconnected table for your slicer and a measure. See attached, Page 8, Table14 and Table 4.
Table 4 = VAR __table = SELECTCOLUMNS(ALL('Table14'[C1]),"Value",[C1]) VAR __table1 = SELECTCOLUMNS(ALL('Table14'[C2]),"Value",[C2]) VAR __table2 = UNION(__table,__table1) RETURN DISTINCT(__table2) Measure 13 = VAR __value = MAX('Table 4'[Value]) VAR __c1 = MAX([C1]) VAR __c2 = MAX([C2]) RETURN IF(__c1 = __value || __c2 = __value,1,0)
Is it possible to make multiple selections? 😭
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |