Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hide blank columns Multi-Row Card View

Hello, I'm trying to use a Multi-card view to display the results of a change intake form. Only the values being changed on the intake form need to be displayed. I'm new to Power BI and wondering if...
Need Help
joarvat's avatar
joarvat
Regular Visitor
3 years ago

I have a similar problem.  To get the measure to deliver a 0 result instead of a BLANK() is not a problem.  However, a 0 does not solve my problem.  If my measure delivers blank, it is because the number can't be computed, it is UNKNOWN.  Unknown is not the same as 0.  So ideally I would like an empty string in that case, but the measure does not allow me to return a text in a measure that otherwise delivers a decimal.  Conditional formatting or filter on the multi-row card does not work, because then BOTH values disappear, not just the one I don't want (I have two values on the card).  Does anyone have an idea?

MFelix's avatar
MFelix
Super User
3 years ago

Hi joarvat 

 

In this case if you want to present the logic on a card the best option is to create an additional metric that you use only on the card, since has you refer the metric needs to be converted to text just use one of the logic below:

 

MEasure VAlue = IF([Measure] = BLANK(), "", [Measure])

Measure Value = COALESCE([Measure], "")