Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Slicer header - in "Between" mode the dynamic slicer header does not work

Goal: Dynamic Slicer header shall show the correct text measure content also in "Between" mode 

==

On multilingual reports it is common, to have the slicerheader titled in the language selected by the user.
I realize this by putting the measure txt_UI

 

txt_UI = SELECTEDVALUE('UI Translations'[Text]))

 

as the slicerheader formula.

The translations table is simple. It has 3 columns: Code, Language, Text. 

 

This works beautifully for all slicer types, but not for Integer / Decimal values when "Between" is selected:

 

Dynamic Slicer header OK, until changing to Between on a numeric fieldDynamic Slicer header OK, until changing to Between on a numeric field

After changing to "Between" the measure contents is empty

SELECTEDVALUE becomes Empty and MIN would deliver the first language translationSELECTEDVALUE becomes Empty and MIN would deliver the first language translation

Example of a filter overlay, where the user selects a language in the top left corner - with red the untouched result right after the slicer type change and blue the workaround with manually entered titles in englishRed = REsult, blue are typed in manually as a work aroundRed = REsult, blue are typed in manually as a work around

 

Thanks for bringing user UI experience a step closer to excellence!

 

Status: Accepted

Hi @alexrobe ,

 

We have reproduced your issue and have submitted to internal icm 318713062 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

 

Best Regards,
Community Support Team _ Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Accepted

Hi @alexrobe ,

 

We have reproduced your issue and have submitted to internal icm 318713062 , engineers are doing their best to fix this issue . please be patient and I will give you feedback here once there is any progress.

 

Best Regards,
Community Support Team _ Caitlyn

alexrobe
Advocate III

Thank you very much, great service!👍