Currency Sign

[Anonymous]

Hello,

I have  a slicer with select abel values USD, GBP, and EUR.

I have a grid with Revenue. I have a messure which converts the revenue based on selected currency. I need to add a Column in my Matrix Visual to also show the Currency. Currency short name (USD, GBP, and etc.) coming from the table where the revenue is (column Name = Currency_Short)

Category -------- Revenue ------ Currency
A           -------- Revenue ------ USD

B           -------- Revenue ------ USD

C          -------- Revenue ------ USD

C          -------- Revenue ------ USD

C         -------- Revenue ------ USD

D         -------- Revenue ------ USD

Because I selected USD from the slicer.

[moumipanja · Accepted solution]

The following measure will return the selected value in the slicer. I am assuming that the slicer is created using the Currency_Short_name column from your Table.

Measure = IF( ISFILTERED('Table'[Currency_Short_name]), SELECTEDVALUE('Table'[Currency_Short_name]))