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 there's a way to hide any values that are blank. Example attached.

 

Need Help

8 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi Anonymous,

     

    Go to the visual filters and select the option to not show blanks, should work.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello MFelix ,

      I'm currently displaying a multi-row card in my report, and I also want to display only the values that are not blank. I tried to use the filter of the visual as suggested but it is impossible for me to make it work; it's like frozen. Indeed I can't click and change the menu "Show items when the value is:", neither define a value, neither apply a filter. I tried to relaunch PowerBI and create a new visual but it is still not working. Do you have any idea why?

       

      Thanks,

       

      Mailys

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, 

    You can hide the blank value using a Conditional Formatting rule on the Value. The rule is 'if blank' then select the same color as the card or canvas background. 

    I have created a video tutorial on how to create the conditional rule in data cards, it should work the same in Multi Row cards : https://youtu.be/Xsmbfpa4oCA

    Cheers, Bianca

     

    • 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
        Icon for Super User rankSuper 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