Forum Discussion
Slider filter with USERCULTURE()
I need to filter using USERCULTURE(), I need to have the item of the table for filter , but I need they change by language of user?
If I try to use USERCULTURE(), power bi say me I can't use it in a column!
Hello Robbiema ,
For your first question, the return value of the function USERCULTURE() is fixed in the form of language-country. You want to use the return value of USERCULTURE() to match the user's language. Based on what I have learned so far, this cannot be achieved.
For more information on how to use USERCULTURE(), you can check this document
USERCULTURE function (DAX) - DAX | Microsoft Learn
For your second question, the function of USERCULTURE() is to dynamically display different date formats or currency units according to the user's region, so USERCULTURE() can only be used in measure.
So if you want to use USERCULTURE(),Please use it in measure.
Best Regards,
Jayleny
1 Reply
Hello Robbiema ,
For your first question, the return value of the function USERCULTURE() is fixed in the form of language-country. You want to use the return value of USERCULTURE() to match the user's language. Based on what I have learned so far, this cannot be achieved.
For more information on how to use USERCULTURE(), you can check this document
USERCULTURE function (DAX) - DAX | Microsoft Learn
For your second question, the function of USERCULTURE() is to dynamically display different date formats or currency units according to the user's region, so USERCULTURE() can only be used in measure.
So if you want to use USERCULTURE(),Please use it in measure.
Best Regards,
Jayleny