Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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.
Nathaniel
Proud to be a Super User!
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
Proud to be a Super User!
Hi @leilei787
Starting table.
Selected two columns and then chose unpivot other columns.
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
Proud to be a Super User!
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!
Region | Local Amt | USD Amt | Euro Amt |
Benelux | 10 | 9 | 10 |
Germany | 4 | 4 | 4 |
France | 2 | 2 | 2 |
UK | 1 | 1 | 1.2 |
Hi @leilei787 ,
I think Nathaniel's reply has provided the most appropriate method because DAX could't get the column header name.
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
Regions | Currency 1 | Currency sign1 | Currency 2 | Currency sign2 | Currency 3 | Currency sign3 |
France | 1 | USD | 9 | EUR | 1 | Local |
UK | 2 | USD | 5 | EUR | 4 | Local |
Germany | 3 | USD | 4 | EUR | 12 | Local |
Benelux | 4 | USD | 8 | EUR | 10 | Local |
Hi @leilei787 ,
What is your expected outcome?
Nathaniel
Proud to be a Super User!
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!
Regions | Currency Amount |
France | 1 |
UK | 2 |
Germany | 3 |
Benelux | 4 |
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.
Nathaniel
Proud to be a Super User!
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
Proud to be a Super User!