Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to make a card return predetermined text when no/multiple items in a category selected (example)

https://www.timesunion.com/local/article/More-Capital-Region-students-are-qualifying-for-12497790.php

 

You can see the example a bit down the page under "Free Lunches..."

 

When no counties are selected or more than one, the card at the top returns "Multiple Counties". How is this being accomplished? I've seen asked and answered examples of returning blanks, but not returning text such as this.

 

Based on this discussion (https://community.powerbi.com/t5/Desktop/Make-visual-blank-display-instructions-until-other-visual/td-p/341802) talking about another aspect of the same report, I was able to add this measure. 

Show Text = IF(ISFILTERED(MedianHouseIncome[County]),"","Select County") This currently makes it so that when no County is selected, it gives the desired text. What can I add to this to make it also return text when 2 or more Counties are selected?
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Try this code:

     

    Income Show Text =
IF (
    NOT ( ISFILTERED ( MedianHouseIncome[Geography] ) ),  //No filters
    "Select County",
    IF (
        COUNTROWS ( FILTERS ( MedianHouseIncome[Geography] ) ) > 1, //More than one value
        "Multiple Counties",
        SELECTEDVALUE ( MedianHouseIncome[Geography] ) //else condition, implies 1
    )
)

     

    Hope this helps

    David

6 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Try HASONEVALUE

     

    IF ( HASONEVALUE ([County]), [County], "Multiple Counties" )

    Hope this helps

    David

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks a lot, really helped out! I've almost got it, here's the full code I have right now.

       

      Income Show Text = IF(ISFILTERED(MedianHouseIncome[Geography]),"", "Select County") & IF(HASONEFILTER(MedianHouseIncome[Geography]),FILTERS(MedianHouseIncome[Geography]),"") & IF (HASONEVALUE (MedianHouseIncome[Geography]), "" , "Multiple Counties" )
       
      It works when either one county is selected or when multiple are selected (returning county name and "Multiple Counties" respectively. However, when none are selected, it says "Select CountyMultiple Counties". Any ideas for getting around that?
      • dedelman_clng's avatar
        dedelman_clng
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Try this code:

         

        Income Show Text =
IF (
    NOT ( ISFILTERED ( MedianHouseIncome[Geography] ) ),  //No filters
    "Select County",
    IF (
        COUNTROWS ( FILTERS ( MedianHouseIncome[Geography] ) ) > 1, //More than one value
        "Multiple Counties",
        SELECTEDVALUE ( MedianHouseIncome[Geography] ) //else condition, implies 1
    )
)

         

        Hope this helps

        David