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.
Understanding it seems not possible, can anyone give me some hints or work around on it? Many Thanks.