Forum Discussion
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 it possible to have a text box appear/disappear when a specific item is selected from a slicer? If so, how?
Thanks in advance!
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.
14 Replies
Anonymous can you give more information, like what you want to do with the text box, display information? based on what?
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!
