Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
avitoriasrocha
Regular Visitor

How to show zero values in a matrix

Hello guys!

I need a lot of help with the following:

In an matrix, I put the priority as a criterion and the rankings as follows in the image:

Captura de tela 2022-11-25 145530.png

In this case, there is also a priority "Critical", but depending on what was filtered in "Final Group", this priority does not appear as it has no value.

I would like to know if it is possible to make it so that even having no value, it is possible to show the priority "Critical" with a value of zero.

I don't know if I made myself clear, I tried to explain as best I could!

Thanks for your attention in advance.

1 ACCEPTED SOLUTION
PabloDeheza
Solution Sage
Solution Sage

Hi @avitoriasrocha !
Try an if condition like:

IF(
	value = BLANK(),
	0,
	value
)

Let me know if that helps!

View solution in original post

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

You can try the following measure:

Show 0 if critical =
IF (
    SELECTEDVALUE ( 'Priority Table'[Priority] ) = "Critical",
    COALESCE ( [Your measure], 0 ),
    [Your measure]
)




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






KNP
Super User
Super User

I'm answering from my phone so I'll do my best to explain without screenshots.

One way to do it...

  • Select the visual that you want priority to show all for.
  • In the field well (I think that's what it's called) in the visualisation pane on the right, where you drop your fields in for the visual, right click on priority and select 'Show items with no data'

Let me know if that helps. 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
PabloDeheza
Solution Sage
Solution Sage

Hi @avitoriasrocha !
Try an if condition like:

IF(
	value = BLANK(),
	0,
	value
)

Let me know if that helps!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.