See the blanks in the slicer when I apply a single selection in the slicer.

[Anonymous]

I have table1 as data entry and I want to add a single selection slicer (baseline_name column) for my stacked area chart with 3 categories to stack. as, the first part of my plot does not have information in baseline_name and it is blank. How can I force the slicer to always show the blanks?

Now, I have to select "Blank" and another option to be able to see all my plot, whereas with a single selection, it is not possible.

[Anonymous]

Hi @Anonymous ,

Based on the information, try using the following DAX formula to filter.

Filter = IF(or(ISBLANK(SELECTEDVALUE(Table[baseline_name])),(SELECTEDVALUE(Test[baseline_name])=SELECTEDVALUE(Table[baseline_name]))),1,0)

You can view the following links to learn more information.

Solved: Slicers - force '(blank)' option and select from o... - Microsoft Fabric Community

Solved: Blank option in Single-select slicer with other op... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

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

[Anonymous]

could you please explain how should i use this dax formula?

[Anonymous]

Hi, 

Creating the new measure, using the dax formula. Then, drag the measure to the visual Filters Pane and set the show item is 1.

Best Regards,

Wisdom Wu

[Anonymous]

Hi @Anonymous ,

Slicers are coming from only one table ?

Can you share the sample data in onedrive and paste the link for working out a solution.

Cheers

CheenuSing