Hi Expert, How can I resolve a problem with a Power BI slicer or custom slicer?

[Omesh]

Even after configuring the slicer to display values from 1 to 5 and applying a filter to exclude 0, the issue persists, showing the value for 0 when I select 1. Please note that using a page-level or visualization filter to exclude 0 is not a suitable solution in this scenario. 
Data:

Visual: Slicer with matrix, Exclude 0 from slicer

when slicer make it to 1 still showing value for 0.

Any suggestions on how to resolve this?
Thanks in advanced 

[Omesh]

Hi @Anonymous The solution provided, which includes a visual-level filter, is not suitable for my situation.  
Slicer 

[Anonymous]

Hi @Omesh ，

I am very sorry for not helping you, After my testing, I'm sorry that the current FEATURES don't meet your requirements.

You can go to this forum and submit your feature request and suggestion .

Home (microsoft.com)

Best Regards,

Albert He 

[Omesh]

Hi @Anonymous , Thank you for your response, is this cannot be achieved in the current version of Power BI (November 2023)? 

[Anonymous]

Hi @Omesh , 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient.  

Best Regards,

Albert He

[Omesh]

Thank you 

[Dangar332]

HI, @Omesh 

try to replace 0 with null in power query
it help

[Omesh]

Hi @Dangar332
Thank you for your response. The client has requested that I convert null values to zero. I need to include zero due to other data dependencies. The issue arises when using a slicer; when it's set to "tile," the output is perfect, but when changed to "between," a problem occurs. Is there a possible solution to exclude zero from the slicer? Please refer to the attached PBIX file for more details.

[Anonymous]

Hi @Omesh ,

About your problem, I think you use filter on this visual, like this:

To achieve your goal, I think you can follow these steps:

Here are my test data:

1.Choose slicer visual in visualizations pane

2.Drag row column to slicer filed

3.Configure filter on this page

4.Final output:

I hope this solution will help you ,if not ,please provide more conditions that you met this situation, or provide .pbix file.

^{In order for you to solve the problem faster, you can refer to the following documentation}

How to Get Your Question Answered Quickly - Microsoft Fabric Community

^{Best Regards,}

^{Albert He}