Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!
@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.
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
@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.