Forum Discussion

pigsinblankets's avatar
pigsinblankets
Icon for Helper II rankHelper II
2 years ago

Rename (blank) on filtered visual

Good Morning, 

 

I have a gauge visual where I've filtered out certain projects so it shows as (blank) - is there anyway using a measure or other method to rename this (Blank) label for the specific projects that have been filtered out on the visual?

 

Thanks! 

General Comment
Need Help
Show and Tell
Tips and Tricks

3 Replies

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

    Hi pigsinblankets ,

     

    Depending on the visual you are using if this a card visual you can use the new car visual that allows to have  a show blank as option.

     

    If you want to change you measure you can do something similar to this:

    No blanks measure = COALESCE([YourMeasure], "")

    Now use this one on that visualization

    • pigsinblankets's avatar
      pigsinblankets
      Icon for Helper II rankHelper II
      2 years ago

      Hi MFelix ,

       

      Thank you for this, are you able to show an example of [YourMeasure] and what would be used here please? I have very rarely used measures so far!

       

      Thank you 🙂  

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

        Hi pigsinblankets ,

         

        This can be several things, in your specific case what what you using in the visualizations? is it a measure? Is it a column making a summarization?