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.

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.