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
Solved! Go to 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.
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.