Multi currency with correct display label

[Anonymous]

i all,

Below matrix can show sales in Local Country Currency and Home Country currency (HKD) by clicking slicer and everything look good.

I can show the correct currency label (EUR; GBP; USD) for the local currency view as one item can sell in different countries as below screen scap. 

However, I got a problem to show the currency lable for the HKD view. All value are correct, but I dont know how to change the label to "HKD" (it is fine to have multipule lines)

I uploaded my Power Bi file for the data and structure.

Can anyone give me some hints or recommendation? Many Thanks.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I noticed that you have two extra columns: “Sales $ (HKD)” and “GM  (HKD)”. You can use these two measures to create a similar visual in the form of HKD display, switching Local currency and HKD as bookmarks.

Note: Do mask sensitive data before uploading.

Best Regards,

Eads

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