Default value to be show on visuals by measure slicer filter

[ssk_1984]

Hi All,

Help to create a measure to show the default value as for category B in visuals for the first time, any selection happen on category slicer automatically the respective values show show on the visual

Catgory		Slicer Category
A		A
A		B
B		C
B
C
C			Cou t of category
		Card Default Value	2

Thanks in advance

[v-stephen-msft]

Hi @ssk_1984 ,

Did Sahir_Maharaj's workaround help you?

If not, you may refer to this blog:

How to dynamically select the default values we ne... - Microsoft Fabric Community

Or provide us with more details about your requirements, thanks.

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.

[Sahir_Maharaj · Accepted solution]

Hello @ssk_1984,

Can you please try this approach:

Measure = 
VAR SelectedCategory = SELECTEDVALUE('Category'[Slicer Category])
VAR DefaultValue = CALCULATE(COUNTROWS('Category'), 'Category'[Slicer Category] = "B")
RETURN 
    IF(ISBLANK(SelectedCategory), DefaultValue, CALCULATE(COUNTROWS('Category'), 'Category'[Slicer Category] = SelectedCategory))