Forum Discussion

cheryl0316's avatar
cheryl0316
Helper II
1 year ago

Field parameter with Numbers - Slicer option doesn't work

I am working on a report translation. The Sales table includes both EN and FR columns, and I want to create a slicer for Price column with style "Less than or equal to" i.e. 

 

Method 1

I created a field parameter for Price/Prix (Translated_Price), linked to the Languages table and used it as a slicer. When I selected the 'Less than or equal to' style, it still showed as a 'Vertical List,' and the 'Less than or equal to' option disappeared.

 

 

Method 2

I used the Price column as a slicer, created a measure for EN & FR header, and applied it as conditional formatting for the slicer header. However, it didn’t work.

 

 

Could someone please explain why the methods above didn’t work? Is there an alternative solution? Thank you!

 

 

https://drive.google.com/file/d/1saDJz1rS7DdfIhOf1q-AqiinkNGJKmcm/view?usp=sharing