Show zero instead of blank in a Matrix visual

[arpanadsk]

Measure 1 = generates the count for the category

Measure 2 = generates the Total

In the below screenshot, I'd like to show 0 for each category which is appearing as blank.

If I add +0 in the Measure 1, it also displays the type which do not have any appropriate values.

Is there a way I can only show the rows where the total is not 0

[Anonymous]

Hi @arpanadsk 

In order for us to fully understand the problem and help you, please provide sample data that fully covers your problem. If possible, sharing your pbix file is best.(Remove sensitive information)

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

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

[quantumudit]

Hello @arpanadsk 

As far as I can understand from your query, you can create a new measure for the category that follows the following logic:

If [Measure 2] <> Blank() and [Measure 1] = Blank() then Blank() otherwise [Measure 1]

See if this trick works otherwise please do the following, so that it will be easier to work and verify the results:

Please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.

Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.

For best practices, you may find the following links useful:

• Need help uploading data?
• Want faster answers?

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User