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,
This may sounds Simple but I was not able to think of a way to implement that.
I have a short list of Vendors:
Vendor A
Vendor B
Vendor C
Vendor D
Vendor E
I would like my users to have a basic slicer (using the slicer visual) that will provide them with the following options:
SlicerName
- "All Vendors Inc. Vendor E"
- "All Vendors Exc. Vendor E"
I put apostrophes because this is the naming convention I would like to use for my users.
The first one should include all members and the second one should include all except Vendor E.
I was trying to use Grouping but this ONLY allows to reaggregate my list of values and doesn't give the option to use ALL members along with a new group that is created.
Also the option of "Select All" in teh slicer format under "Selection Control" doesn't provide an adequate solution to my request.
Any idea how this can be resolved?
Sounds quite simple to me...
Thanks!
NH
Solved! Go to Solution.
Hi @NirH_at_BITeam,
You can add a new table which contains values: All Vendors Inc. Vendor E, All Vendors Exc. Vendor E. Then add this column to a slicer visual, create a measure:
Best Regards,
Qiuyun Yu
Hi @NirH_at_BITeam,
You can add a new table which contains values: All Vendors Inc. Vendor E, All Vendors Exc. Vendor E. Then add this column to a slicer visual, create a measure:
Best Regards,
Qiuyun Yu
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |