Re: Multiple Row Card - Hide Blank Values

Anonymous · ‎10-04-2023

Hello,

I have a multiple card row, with a few metrics.

And depending on which month is selected, some metrics will not be considered (their result will be blank).

I tried using condicional formatting, but it requires a specific field, and here i have many fields.

Also tried replacing the blank with 0, using the +0 at the metrics, but didn't work either.

How can i not show the Metrics that the value is blank (or 0)?

The expected result is this: (i just removed the metric, por example purposes)

Thanks in advance!

parry2k · ‎10-05-2023

@Anonymous what have you tried so far?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎10-05-2023

hello @parry2k

That case didn't really work for me, or i was not able to make it work.

Could you help me on this case?

Thanks

parry2k · ‎10-04-2023

@Anonymous A similar question was posted a few hours ago, check it here Solved: Sorting Multiple Text-Based Measures - Microsoft Fabric Community

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.