Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey!
I have a visual that shows me the flow of people from "From Region" to "To Region". Now if i select a particular region from slicer in "From Region", say A, I would like to see the flow from A to all other regions except A.
Is there a way this can be done?
Solved! Go to Solution.
@Anonymous,
You can create a measure in your table using DAX below. Then drag the measure to visual level filter of your visual and set its value to 1.
Measure = IF(MAX(Table[From Region])=SELECTEDVALUE(Table[From Region])&&MAX(Table[To Region])<>SELECTEDVALUE(Table[From Region]),1,0)
Regards,
Lydia
@Anonymous,
You can create a measure in your table using DAX below. Then drag the measure to visual level filter of your visual and set its value to 1.
Measure = IF(MAX(Table[From Region])=SELECTEDVALUE(Table[From Region])&&MAX(Table[To Region])<>SELECTEDVALUE(Table[From Region]),1,0)
Regards,
Lydia
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |