cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

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

@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

@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

@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

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors