Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Desktop Formatting - I think

Hello Friends,

 

I have a page that displays information for an item. the item information comes from multiple tables. These tables are linked in my model. When I first come into the application, the slicer defaults to ALL. How do I 'clearn out' the fileds until a value is selected from my slicer? Below is a sreen image. All is in the Select Credit Number slicer, yet there are values for creation date, Item URL (bad data) Customer Survey Completed, etc.

 

How do I clear thoese data elements (make them blank) when All is selected for the filter?

 

Cheers,

 

Peter

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Currently there's no such feature in the formatter of the card. You can submit an idea and vote for it: Ideas.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

5 Replies

  • calerof's avatar
    calerof
    Impactful Individual

    Hi Anonymous ,

    How are you showing the values, with Cards? What measure are you using in the Cards?

    If you use this code in the Cards then when no selection is made it defaults to blank:

    Selected Product = 
    SELECTEDVALUE(Table_20211202[Product Name], BLANK())

     

    Hope this helps.

    Regards,

    Fernando

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello,

       

        Thank you for the quick reply. I am using field names in the tables and not using measures. I am using cards, multi-line cards and tables to display the informaiton. Is there a way to set the formatting of a visualization based on the value of my slicer? So when my slicer hass ALL in the field, the other fields are blank?

       

      Sincerely,

       

      Peter

      • calerof's avatar
        calerof
        Impactful Individual

        Anonymous ,

        Did you read my response above?