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.
Hi all,
I have a table with sales manager details recorded as below:
Abbey
AbbeyHazel
Peter
PeterAbbey
Hazel
PeterHazel
Is there any way I can create a filter which will allow me to filter all rows that contain the name "Abbey", "Hazel" and "Peter"?
Many thanks,
Diana
Solved! Go to Solution.
Hi,
Please try to duplicate the original column and use 'Split Columns' function to split duplicated column in Query Editor:
After Apply&Close, create a Slicer table:
Table 2 = DISTINCT(UNION(SELECTCOLUMNS('Table',"A",'Table'[Sales Manage - Copy.1]),SELECTCOLUMNS('Table',"B",'Table'[Sales Manage - Copy.2])))
Then create a check measure:
Measure = IF(SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.1])||SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.2]),1,0)
Apply this measure=1 to the visual, when you choose a name in slicer, the result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
Please try to duplicate the original column and use 'Split Columns' function to split duplicated column in Query Editor:
After Apply&Close, create a Slicer table:
Table 2 = DISTINCT(UNION(SELECTCOLUMNS('Table',"A",'Table'[Sales Manage - Copy.1]),SELECTCOLUMNS('Table',"B",'Table'[Sales Manage - Copy.2])))
Then create a check measure:
Measure = IF(SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.1])||SELECTEDVALUE('Table 2'[A]) in FILTERS('Table'[Sales Manage - Copy.2]),1,0)
Apply this measure=1 to the visual, when you choose a name in slicer, the result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi Giotto,
I like this... Way leaner than the solution I have (which involves uploading seperate datalists for each manager...)
My next obstacle though is that I'm trying to have my visual looks like this:
But for this filter to work, I have to include manager info in my table:
When I take away the Manager columns, the filter stops working and pulling in data from everyone...
I would very much appreciate your insight on this.
Many thanks,
Diana
Are you going to select these values in a slicer?
If yes, then refer to this example. Not the same but when each value is selected you can use search and find and build the final result.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Thanks for your reply.
I'm still wrapping my head around on how I could apply this approach to my data and make it work... (Being a newbie certainly doesn't help...)
I'll let you if I make any progress on this 🙂
Diana
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |