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 

 

As a follow-up to this. Is it possible to manipulate the measure to show if a particular value is entered in.

 

For example, if someone entered 'Apple' into the text filter it would show the data, but if they entered 'Orange' it wouldn't?

 

Any ideas?

 

Kindest regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    You can create a measure as below:

    Measure 2 =
IF (
    HASONEVALUE ( 'Fruits'[Fruit] )
        && VALUES ( 'Fruits'[Fruit] ) = "Apple",
    [Measure],
    ""
)

    Best Regards

    Rena