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 a simple two table model, sales and salesperson. I want a slicer using the SalespersonName from salesperson, but only show the salespeersons in Sales. When I add the slicer and drop in salesperson name I get all salespersons, many of whom have do not have any sales and it just clutters up the slicer.
Is there any way to filter a slicer based on what is in the child table?
I think my only option is to create a view of just salespeople on sales orders.
Only thing I can think of is possibly use the disconnected table trick.
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |