Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Conditional Appearance of Text Box?

I have build a product pricing tool in Power BI that requires our representative to select a series of options in a slicer to prduce a cost and unit count.  Because each product has its nuances, is i...
Need Help
Show and Tell
  • pschommer's avatar
    pschommer
    9 years ago

    I was on a mission and couldn't stop. The following will account for multiple selections. Given our individual handling of the fruit, I chose to give the same message whether zero or multiple selections were made.

     

    Warning Message = IF(AND(ISFILTERED(tblFruit[Name]),HASONEVALUE(tblFruit[Name])),IF(OR(VALUES(tblFruit[Name])="Apples",OR(VALUES(tblFruit[Name])="Grapes",VALUES(tblFruit[Name])="Pears")),"Wash " & VALUES(tblFruit[Name]) & " before eating.",""),"PICK ONE FRUIT!")

     

    BOLD is still new from the original.

    IF the fruit has been filtered and IF there is only 1 fruit value, go ahead and put up a message. Otherwise (zero or multiple selected), tell the user to make a SINGLE selection.

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Anonymous can you give more information, like what you want to do with the text box, display information?  based on what?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Within the Slicer, the representative has to pick a product.  As an example, Apples or Oranges.

 

When the representative picks apples, I would like a text box that appears "Recommend to customer to wash apples before earting."

 

Conversely, if the representative picks Oranges in the slicer, no text box would appear.

 

Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      This is absolutelty what I am looking to do, but I am struggling with the DAX statement.  Using my example can you construct the DAX for me to follow the argument?

      • pschommer's avatar
        pschommer
        Helper II
        9 years ago

        Something like this should do the trick:

         

        Warning Message = IF(VALUES(tblFruit[Name])="Apples","Wash apples before eating.","")

         

        "Warning Message" is a measure.

        tblFruit is the table name.

        [Name] is the field name containing the name of the fruit.

         

        Add this measure to a card.

        If the user selects "Apples" from the slicer, the card populates with "Wash apples...". If anything else is selected, null is displayed in the card - it looks blank.

        This does not work if more than one fruit is chosen in the slicer.