Suppress 0 in Field Parameters

[SCallanan]

Hi guys,

just wondering if you can help me with this...

I created a field paramter based on two measures and added a bar-chart which now shows a lot of 0 values. 

In the filter pane I tried to exlude 0 and or blanks etc but it doesn't work as it will hide the content of the other field parameter. 

Example below:

Dax Measure that causes the problem is the following: 

I tried both versions, but it does not change the outcome of the output. 

Admin = [Total Inspections]-[Physical] 

or 

Admin = IF ( ISBLANK ([Total Inspections] ), BLANK (), ( [Total Inspections]-[Physical] ) )

Field Parameter: 

Physical/Admin Slicer = {

    ("Physical", NAMEOF('Power BI - Inspections'[Physical]), 0),

    ("Admin", NAMEOF('Power BI - Inspections'[Admin]), 1)

}

This only happens when the Admin Slicer is selected. 

     

I can choose to not select 0 in the filter pane, but that hides all the Physical values then when Physical is selected. 

 

  

Thanks for your help. 

[ahadkarimi]

Hey @SCallanan, could you please share a sample of your PBIX file? That would help me assist you better.

[SCallanan]

@ahadkarimi thank you for getting back to me. Where can I attach the pbix file for you? I can't publish it to the public to share the link.

[ahadkarimi]

@SCallanan you send it by gmail ahad.karimi8@gmail.com, after sending email let me know here one the email has been sent.

[SCallanan]

Hi @ahadkarimi I emailed that to you. Thanks for your help. 🙏

[ahadkarimi]

[ahadkarimi · Accepted solution]

Hey @SCallanan, please update the admin measure, and let me know if you encounter any issues.

Admin = IF([Total Inspections] - [Physical] = 0, BLANK(), [Total Inspections] - [Physical])

[SCallanan]

@ahadkarimi 
Fair play to you Ahad. That worked. 😊

Many thanks. 👍

[ahadkarimi]

Glad to hear it worked, Sandra! You're very welcome.
Happy to help! 😊