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?