Drill Through Report

[Anonymous]

Dear Team,

When we open drill through report by passing the parameter, report gets filtered properly and slicer also shows only one value which has been passed from source report. 

But that value is not selected in slicer. Due to this, in other control, I used an expression to find the selected value with ISSELECTED function, is not working and showing all the values in that control.

Is there any way to select the slicer value. 

Thanks,

Deepak

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

@Anonymous,

If one value a time, you can try this.

Measure =
IF ( HASONEVALUE ( 'Product'[Color] ), VALUES ( 'Product'[Color] ), 0 )

Best Regards!

Dale

[MFelix]

Hi @Anonymous,

I don't know how you want to use the value you are fectching but if you use the expression:

Slicer_Value = MAX (Table[Column])

However if you have more than one value selected in the slicer you can try and use this formula to get a concatenated list of the values:

Slicer_Selection =
CONCATENATEX ( VALUES (Table[Column] ), Table[Column], ", " )

Check this link with a full explanation

Regards,

MFelix