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

Does anyone else have any ideas on this subject?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I created a sample pbix file for you, please check whether that is what you want.

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

     

    I'm not sure I understand, but thank you so much for your reply.

     

    Unless I'm missing something, the PBIX has a slicer which splits between apple and orange, however I couldn't see a mechanism whereby an entry in a text filter visual has the power to show or hide visuals.

     

    As an example...my desired outcome would be this...

     

    I've added the text filter visual to the report you supplied, and hidden the rest of the visuals.

     

    When the user types in say, Apple into the text filter and hits search or return, then some pre-made, but hidden card visuals appear in the report, and hide again when the search box is cleared.

     

    I realise thats a huge ask, but what are your thoughts?

     

     

    • 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.