Combine and group selected vendor from 2 slicers(Group 1 slicer and Group 2 slicer)

[RudyV]

Hi, Good day. I'm a powerbi newbie and working on a requirement to combine group of vendors from 2 vendor slicers(Group 1 and Group 2) . The use case is a vendor comparator-heat map where I created 2 slicers and user will select a group 1 vendors and group 2 vendors(both are multi select) and I have a bubble map where I put the province in the Location parameter and I put the grouping("Group 1" for vendors selected in slicer 1 and "Group 2" for vendors selected in slicer 2) in the Legend parameter and I put the sales$ in the bubble size . So I created a dax colum to identify the selected vendors from the 2 vendor slicers. Please note the 2 slicers have the same list of vendors and user need to select which vendor to group in Group 1 from Slicer 1 and which to group in Group 2 from Slicer 2. See below my dax colum code but the result didn't give the output I expected. So the code perfectly capture the selected vendors from each slicers but it only group under group 1 even if user selected Microsoft and Acer in Slicer 2. See below my dax code and my validation table where it grouped all selected vendors only to Group 1 and see as well my bubble map where the bubble is only showing group 1. So can you check what's wrong with my dax code or is there a better solution you can suggest. Thanks a lot in advance and I will appreciate any help you may extend.

Just an additional info. I only have one fact table and 2 slicers and one bubble map.

[Anonymous]

Hi, @RudyV 

According to your description, you want to realize the merging and grouping of selected suppliers using the slicer, in fact, in the current version cannot realize your needs, to realize the grouping you must create a Column, the Column is a fixed value after the creation of a fixed value, will not change with the change of the slicer. You can submit an idea for here and the product team will take note of such a need. Or you can solve your problem in other ways, such as whether or not to create snapshots.

Related Link: New tab (powerbi.com)

Whether or not to create snapshots: Like-for-like comparison – DAX Patterns

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[RudyV]

Hi Yang,

Thanks for the feedback. I already applied the same temp solutions that you mentioned for a specific vendors that user required  and hardcoded it in a new column but since different users maintain different vendors I need now to make  it dynamic where it will be controlled by slicer . Anyway, will take a look in the reference link that your shared for snapshot concept. Thanks again and will let you know for any progress.

Regards, 

RudyV

[RudyV]

Hi Yang, Hope all is well with you. Just an fyi that I figured out the solutions for my grouping issue and I just created a dax new table with the union of group 1 slicer and group 2 slicer and created a measure evaluating if the vendor exist in the selected slicer for both grouping. See below. 

Regards,

RudyV