When applying a filter, show always one value as well as the selected option

[gianmarco]

Dear All,

When applying a filter I want the result to always show one value, as well as the selected option.

The fields are as below:

0

1

2

3

I want the filter to only show options 1, 2 & 3.

When a user selects 1, 2 or 3 I want all items connected with value 0 to also remain in the visualized results.

Is there a way I can obtain this result?

Thank you

gianmarco

[v-jianboli-msft · Accepted solution]

Hi @gianmarco ,

Based on your description, I have created a simple sample:

Please try:

First add a new table for slicer:

For Slicer = 
var _a = FILTER(SUMMARIZE('Table',[Column1]),[Column1]<>0)
var _b = CROSSJOIN({0},_a)
var _c = ADDCOLUMNS(_a,"Value",[Column1])
return UNION(_b,_c)

Output:

Then create a relationship between the two tables:

Create a slicer:

Final output:

Best Regards,

Jianbo Li

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