topic Re: Suppress 0 in Field Parameters in DAX Commands and Tips

Suppress 0 in Field Parameters

SCallanan — Wed, 14 Aug 2024 09:45:34 GMT

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]

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 — Wed, 14 Aug 2024 14:19:23 GMT

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

SCallanan — Wed, 14 Aug 2024 15:21:08 GMT

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 — Wed, 14 Aug 2024 22:38:11 GMT

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

SCallanan — Thu, 15 Aug 2024 07:32:57 GMT

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

ahadkarimi — Thu, 15 Aug 2024 13:20:00 GMT

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])

ahadkarimi — Thu, 15 Aug 2024 13:27:03 GMT

SCallanan — Thu, 15 Aug 2024 13:52:30 GMT

ahadkarimi
Fair play to you Ahad. That worked. 😊

Many thanks. 👍

ahadkarimi — Thu, 15 Aug 2024 13:57:34 GMT

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