How to handle multiple currency columns?

[Anonymous]

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

[Kaviraj11 · Accepted 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)

[Anonymous · Accepted solution]

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.

[Kaviraj11 · Accepted 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)