Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
507 views
in Power BI by 4 4 7
edited by

I am working on a Power BI desktop and I want to exclude the blank value in a slicer.

filter in slicer in power bi

I tried to add a field on the visual level filter for slicer and it doesn't accept any field. and I can't exclude the blank value in a slicer.

Is there any workaround to apply a filter on slicer in Power BI?


1 Answer

1 like 0 dislike
by 54 119 241
selected by
 
Best answer

Apply a filter on slicer in Power BI

Looks like you are using an older version for Power BI Desktop! where the Visual level filter for slicers is now available in Power BI Desktop June 2019 and later.

Exclude blank value in slicer in powerbi

In Power BI Desktop June 2019 and later, you can

  • Apply a filter on a slicer like any other visual level filter.
  • Apply a filter only on the slicer and no other visuals.

For more details, Please check Power BI Desktop June 2019 Feature Summary


Exclude a blank value in slicer in Power BI

As a workaround for earlier Power BI Desktop versions:

You can apply a filter on a slicer by

  • Applying a Page filter instead of a visual filter that will not accept any field as you said.

    can't exclude the blank value in a slicer

Note: This workaround will exclude the blank values on a slicer and all other visuals on the same page.

Read more at Power BI: Filters on Slicers.

If you don’t ask, the answer is always NO!
...