cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leilei787 Frequent Visitor
Frequent Visitor

slider that let me select different currency

Hello, i am working on a project and got stucked. here is my problem

 

let's say i have 4 columns:

 

1st column is territories: France, Germany, UK and Benelux. 

2nd column is local amount ( so France, Germany and Benelux are EUR, UK is GBP)

3rd column is USD amount 

4th column is Eur amount 

 

i want to create a currency slider that when i select USD, the table will show USD amount, or if i select Eur, it will show Euro

 

please help!

 

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 ,
PBIX is HERE  Dashboard is HERE Remember only on the Euro page are all buttons hooked up.
You could do something like this.  Add  3 columns, 3 which reference the value column.  Then format each column to the currency.  Then create three pages, three buttons, three pages. You can hook up each button to a different page, and each page has a different currency.  Do the hookup of the buttons on one page, and then copy to the other pages, otherwise you will have to do it on each page.  So mine, the Euro page buttons are working. Use CTRL click on the buttons, although your clients will just click.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathanielcur123456.PNG


Euros.PNG
cur12345.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

9 REPLIES 9
Highlighted
Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 ,

This is what you are looking for, I believe. You will need to unpivot your table.  I will provide steps and pbix in a moment.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

cur.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 cur1.PNG

Starting table.

cur12.PNG

Selected two columns and then chose unpivot other columns.


cur123.PNG

Go to Transform tab, Select Unpivot Columns, in the drop down select Unpivot Other Columns. Go back to Power BI, and drop the column that is labelled Attribute in this picture on the Slicer.

 

Here is the PBIX  MY PBIX FILE 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




leilei787 Frequent Visitor
Frequent Visitor

Re: slider that let me select different currency

Hi Nathaniel

 

thank you for your help!

 

the solution is bit different from my expectation. i was thinking to use functions such as selectedvalue, switch to create some kind of dynamtic field. because the dataset that i am using is very large, i feel unpivot may mess up everything....are there functions that i can use?

 

again here is an example. i want to have a slider that can select Local, USD and EURO. the goal is to have one data column that can show all three currencies when it is choicen.  Appreciate your time!

 

 

RegionLocal AmtUSD AmtEuro Amt
Benelux10910
Germany444
France222
UK111.2

 

 

Community Support Team
Community Support Team

Re: slider that let me select different currency

Hi @leilei787 ,

 

I think Nathaniel's reply has provided the most appropriate method because DAX could't get the column header name.

 

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

Re: slider that let me select different currency

thank you everyone. what if i format the dataset this way. can this format use any of functions to work on the slider? so the goal is to show single currency. but user can choose: USD, Eur and local

 

thank you again

 

RegionsCurrency 1Currency sign1Currency 2Currency sign2Currency 3Currency sign3
France1USD9EUR1Local
UK2USD5EUR4Local
Germany3USD4EUR12Local
Benelux4USD8EUR10Local
Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 ,

What is your expected outcome?

Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 ,

If what you are asking, is can you format different columns with different formats, you can by formatting the underlying datasets in Power BI.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

cur1234.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




leilei787 Frequent Visitor
Frequent Visitor

Re: slider that let me select different currency

hi Nathaniel

 

the expected out is like this where user can select Local, Eur and USD. And Currency amount will change accordingly. 

 

again appreciate your help!

 

RegionsCurrency Amount
France1
UK2
Germany3
Benelux4
Super User IV
Super User IV

Re: slider that let me select different currency

Hi @leilei787 ,
PBIX is HERE  Dashboard is HERE Remember only on the Euro page are all buttons hooked up.
You could do something like this.  Add  3 columns, 3 which reference the value column.  Then format each column to the currency.  Then create three pages, three buttons, three pages. You can hook up each button to a different page, and each page has a different currency.  Do the hookup of the buttons on one page, and then copy to the other pages, otherwise you will have to do it on each page.  So mine, the Euro page buttons are working. Use CTRL click on the buttons, although your clients will just click.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathanielcur123456.PNG


Euros.PNG
cur12345.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors