Clear Selection option on single select filter card

[ReginaldPenguin]

Hi,

I have a report for a client which requires use of filter cards some of which are single select. During a demo my client clicked the clear selection option (the eraser option) which led to them being confused as to what they were seeing, these are just end users and not familiar with Power BI in the same way we might be.

As this is single select and it should never show all can the option to clear selection be removed at all?

Using slicers instead is not a workable solution

Thanks

[v-luwang-msft · Accepted solution]

Hi @ReginaldPenguin ,

Please new a measure:

Measure1 =
CALCULATE ( IF ( ISFILTERED ( Table[Column] ), 1, 0 ), ALLSELECTED ( Table ) )

Add this measure to visual level filters, and set its value to 1.

Best Regards

Lucien