Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Hopeful question

Hi all   Hoping you might have a definitive answer for this one.   My client has asked if it is possible to use text to determine what visuals are shown in the report. I am aware of the 'Text Fil...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I updated my sample pbix file, you can get it from this link. The updated information as below:

    1. Add a Text Filter visual

    2. Create a measure as below and create two mask cards used this measure

    Message = 
   IF(
      ISFILTERED('Fruits'[Fruit]),
      "",
      "You must input any value in text filter to see the results"
   )

    3. Create a measure to display or hidden the cards and format the background color of mask cards with this measure

    Make Transparent = 
      IF(
         ISFILTERED('Fruits'[Fruit]),
         "#FFFFFF00",
         "White"
      )

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I updated my sample pbix file, you can get it from this link. The updated information as below:

1. Add a Text Filter visual

2. Create a measure as below and create two mask cards used this measure

Message = 
   IF(
      ISFILTERED('Fruits'[Fruit]),
      "",
      "You must input any value in text filter to see the results"
   )

3. Create a measure to display or hidden the cards and format the background color of mask cards with this measure

Make Transparent = 
      IF(
         ISFILTERED('Fruits'[Fruit]),
         "#FFFFFF00",
         "White"
      )

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

This is a really beautiful solution to the problem.

 

Thank you so much for taking the time to respond to me, and for the information provided. It truly is appreciated.

 

Kudos given, and very very much deserved.