Forum Discussion

AlexisKMX's avatar
AlexisKMX
Frequent Visitor
4 years ago

Hide Blanks

Hello everyone!

How can I hide the name of the countries when it is a blank value?, i know how to do it with numerical values but the column of the countries is type text.
I want to delete or hide the (Blanks) automatically. 

 

 

Need Help
Tips and Tricks
Tutorial Requests

5 Replies

  • Seanan's avatar
    Seanan
    Solution Supplier
    4 years ago

    Hi AlexisKMX,

     

    Are you using a multi-row card to display your text values? If so you can click on the visual and in filter pane, expand the filter card -> click select all -> untick the (Blank) option.

    • AlexisKMX's avatar
      AlexisKMX
      Frequent Visitor
      4 years ago

      What i want is to not show the (Blank) text, there are some weeks that have more countries. 

       

      I just want to hide the (Blank) text when they are no countries to show there. I want to achieve this.. ( in the image i just inserted a white rectangle to hide the (blank))

       

      • Seanan's avatar
        Seanan
        Solution Supplier
        4 years ago

        Hi AlexisKMX,

         

        I believe what I posted above should help you achieve this. If that is not the case, would it be possible for you to send a copy of the PBIX file with any of the sensitive data removed?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AlexisKMX ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a measure.

    Measure = IF(MAX('Table'[id])>=6,"",MAX('Table'[Country]))

    Change the blank to "".

     

    If I have misunderstood your meaning, please provide you pbix file without privacy information.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    What visual are you using?

    There are a number of ways of achieving what you are after.

    With this sample data:

     

    You can use a Card Visual and a measure along the lines of:

    Concatenate Countries =
IF (
    ISFILTERED ( FactTable[Week] ),
    CONCATENATEX (
        VALUES ( FactTable[Country] ),
        FactTable[Country],
        UNICHAR ( 10 )
    ),
    ""
)

    With a table visual and a measure to use as a filter in the filter pane:

    List Countries =
IF (
    ISFILTERED ( FactTable[Week] ),
    COUNTROWS ( VALUES ( FactTable[Country] ) )
)