cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## create a currency slicers with multiple rates

Hi,

I'm trying to create a currency slicer with multiple exchange rates (on a monthly basis).

I've tried the following formula:

Applicable Exchange Rate = CALCULATE(VALUES(Tabelle1[FX Rate]);FILTER(ALLEXCEPT(Tabelle1;Tabelle1[FCURR]);Tabelle1[TCURR]= SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[waers]) && Tabelle1[Period - Date Format] = SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[jjjjmm])))

Revenue in Selected Currency = [Applicable Exchange Rate]*SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[ums])

however it does not work. Anybody has an idea?

And would it be possible to combine the currency slicer for further measures on the same workbook (f.e. not only slicer for revenue, but also for the order amount, costs,...)?

Thanks a lot for your help,

Regards

8 REPLIES 8
Microsoft Employee

Could you please share the sample data in a Excel file so that I can copy and paste? Also please post expected result based on the sample data you post.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

@v-yuezhe-msft

Hi Lydia,

here the link to the excel file with the two tabs (currency rates + sales). Data Example

the column "waers" in the Sales tab is always in local currency. Based on the respective period + rate, I would like to select with the slicer the sales (column "ums")  converted to the different currencies. In addition if possible I would like also other columns (f.e. umsp) converted with the same currency slicer.

many thanks & regards

Microsoft Employee

@MK_Aqipa,

I am unable to access the data you shared as it requires permission.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

@v-yuezhe-msft

would you have another idea how to share excel files here in the community?

Microsoft Employee

@MK_Aqipa

You can share the file via OneDrive or dropbox, make sure the file you share doesn't require access.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

@v-yuezhe-msft

Thanks & BR

Frequent Visitor

@v-yuezhe-msft

Hi Lydia,

was the download of the data possible? If yes, did you have any luck to look into the data?

Thanks a lot,

BR

Microsoft Employee

@MK_Aqipa,

Please check if the DAX in the PBIX file below returns your expected result.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements