Desktop Formatting - I think

[Anonymous]

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

[calerof]

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]

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]

@Anonymous ,

Did you read my response above?

[Anonymous]

Hello,

   Yes, but if I understand your solution; I would have to create a measure and use that measure in my card. I am hoping there is a solution that would not require creating a measure. Is there a way to do this in the formatter of the card?

Sincerely,

Peter

[Anonymous · Accepted solution]

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.