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.
I have created the table below, as an example of a part of my query. My query is a combination of several reports / excel-sheets, which include transactions with a sender name and a receiver name.
I want to create a slicer filter showing all sender+receiver locations, where if I in example choose to filter by "New York", it will show all rows where "New York" is mentioned either as sender or receiver. So in this example, it should show row numbers: 1, 2 and 8. How can I develop such a slicer filter?
Row number | Report number | Sender | Receiver |
1 | 1 | New York | Berlin |
2 | 1 | Beijing | New York |
3 | 1 | Paris | Berlin |
4 | 2 | Los Angeles | Madrid |
5 | 2 | Los Angeles | Berlin |
6 | 3 | Tokyo | Madrid |
7 | 4 | Dubai | Copenhagen |
8 | 4 | New York | Beijing |
9 | 4 | Berlin | Paris |
Solved! Go to Solution.
Hi Maami,
First step is to create a calculated column in the table to combine the sender and receiver values.
Hi Maami,
First step is to create a calculated column in the table to combine the sender and receiver values.
This worked like a charm, thanks!
create a slicer that did not join to this table
And use this measure in you table of matrix
measure =
var _max = maxx(Slicer,Slicer[city]) // values(Slicer[city])
return
calculate(countrows(table),filter(table,table[Sender]=_max || table[Receiver]=_max))
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 |
---|---|
110 | |
96 | |
76 | |
63 | |
55 |
User | Count |
---|---|
142 | |
107 | |
89 | |
84 | |
65 |