Forum Discussion
Drill Through Report
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
Anonymous,
If one value a time, you can try this.
Measure = IF ( HASONEVALUE ( 'Product'[Color] ), VALUES ( 'Product'[Color] ), 0 )
Best Regards!
Dale
3 Replies
- MFelix
Super User
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
v-jiascu-msftMicrosoft Employee
Anonymous,
If one value a time, you can try this.
Measure = IF ( HASONEVALUE ( 'Product'[Color] ), VALUES ( 'Product'[Color] ), 0 )
Best Regards!
Dale
- 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
