How to handle multiple currency columns?

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)

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.