Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using measure in slicers

Hi everyone,   I am new to Power BI, and thanks to the community, I have created a measure to covert two currencies with a fixed rate. Solved: Fixed rate currency conversion to display on matri... ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    Measures are not supported in slicer, but you can use it in the visual filter.

    Or you can create a calculate column istead of a measure.

    Amount USD column = 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 )

    I attach my sample below for reference.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak, in this case, I only want the slicer to have the USD value. Thanks