Forum Discussion

jagvdelsen's avatar
jagvdelsen
Frequent Visitor
3 years ago

How to use the SelectionIdBuilder to select all matching values on drilled categorical data?

Hi, We are currently implementing a custom visual that supports multiple categories on a categorical slot. When drilling down to the lowest level, we would like to be able to select all matching c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jagvdelsen ,

 

I suggest you to create an unrelated DimRegion table for slicer and use a measure to filter your visual.

Here I create a sample to have a test.

Data model:

Measure:

Filter = 
VAR _SELECTREGION = VALUES(DimRegion[Region])
VAR _PRODUCTLIST = CALCULATETABLE(VALUES('Table'[Products]),FILTER(ALL('Table'),'Table'[Region] IN _SELECTREGION))
RETURN
IF(MAX('Table'[Products]) IN _PRODUCTLIST,1,0)

Add this measure into visual level filter and set it to show items when value = 1.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

jagvdelsen's avatar
jagvdelsen
Frequent Visitor
3 years ago

Hi Rico Zhou,

Thanks for your reply.

We are developing a Custom Visual using the Visuals API (visual-api). The SelectionIdBuilder is one of the aspects of this API (selection-api) and we would like to find out how the API for this class works in combination with drilling. This does not have any connection to the solution you provided which lies more on a data level.

Hope this helps!
Jelle.