Forum Discussion
Multi currency with correct display label
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.
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.
1 Reply
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.