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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Bianca,

 

Unfortunately this option does not work, because you need to pick a field as a condition, what will happen is that if that specific field is blank , the entire multi card value color will become the color of the background defined in the example given above, that would mean the entire content would be "hidden" including fields with values.

 

Has anyone else found a solution for this? I am facing the same problem. Seeing the "(Blank)" fields in the report is really not appealing but I can't seem to be able to format at a value by value level.

MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

Have you tried wraping your metric on a COALESCE? that will return the value has empty try the following code:

 

METRIC = COALESCE ( SUM(Table[Column], "")

Be aware that this metric cannot be used then on a chart because the values that have blaknbs being replaced