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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
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.