Switch between multiple columns using buttons/slicer

[Joseph_Hchaime]

Hi

I have a scenario where I have already calculated columns AND Measures in USD and in Local Currency. I read online that it's possible to create a slicer called Currency with USD and Local Currency as options. Where if the user selects USD, ALL the USD calculated columns and measures show up and the LC columns/measures are hidden and vice versa using the switch() function.

However, all the examples i saw were based on a single column or measure. How can I do that for multiple columns/measures? 

for instance: ID=1, Sales in Local Currency,Collection in Local Currency,Balance Outstanding in Local Currency
                     ID=2, Sales in USD, Collection in USD, Balance Outstanding in USD.

[NikhilChenna · Accepted solution]

Hi @Joseph_Hchaime ,

Can you share us the sample how is your data and what output are you expecting from it .

Please check this link it shows how to write a switch for multiple conditions,

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Using-Switch-and-Contains-for-Multiple-Condit...

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[NikhilChenna · Accepted solution]

Hi @Joseph_Hchaime ,

Can you share us the sample how is your data and what output are you expecting from it .

Please check this link it shows how to write a switch for multiple conditions,

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Using-Switch-and-Contains-for-Multiple-Condit...

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Joseph_Hchaime]

Sample of data. I want to create a button or slicer that would hide the LC columns when USD is chosen and vice versa 

[NikhilChenna · Accepted solution]

Hi @Joseph_Hchaime ,

You can achieve this by creating them separtely in a table visual and hide and unhide based on selection.

Please go through this link,

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

https://www.youtube.com/watch?v=QUcW8gudhLw

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!