Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I'm working on the application, the fact table contains multiple currency columns, for instance, Document Currency, Local Currency, and Global Currency, all measures are built in the same style, Sales DC, Sales LC, and Sales GC.
Based on the requirements I should have two sliders, the first slider allows one to select a type of Currency (DC, LC, and GC), and the second slicer selects currency (EUR, USD, etc.).
Do you have any ideas on how to handle this?
ID | LC | GC | DC | Sales LC | Sales GC | Sales DC |
Regards,
Vitalii
Solved! Go to Solution.
Hi,
I would suggest to Unpivot Columns - Currency, Local Currency, and Global Currency & Sales DC, Sales LC, and Sales GC in Power Query seperately as two steps. You will have two attributes and two values as row based. This will help you in Putting the Attribute columns in Slicer.
Power BI Tutorial - How to Unpivot data in Power Query (youtube.com)
Proud to be a Super User! | |
Thanks for the reply from @Kaviraj11 , please allow me to provide another insight:
Hi @Anonymous ,
You might also consider looking at the links and using filed parameters.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
If the above results do not meet your expectations, can you express the expected results in the form of a picture, we can help you better.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from @Kaviraj11 , please allow me to provide another insight:
Hi @Anonymous ,
You might also consider looking at the links and using filed parameters.
Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
If the above results do not meet your expectations, can you express the expected results in the form of a picture, we can help you better.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I would suggest to Unpivot Columns - Currency, Local Currency, and Global Currency & Sales DC, Sales LC, and Sales GC in Power Query seperately as two steps. You will have two attributes and two values as row based. This will help you in Putting the Attribute columns in Slicer.
Power BI Tutorial - How to Unpivot data in Power Query (youtube.com)
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |