Forum Discussion
Switch between multiple columns using buttons/slicer
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.
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,
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a 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!
3 Replies
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,
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!Sample of data. I want to create a button or slicer that would hide the LC columns when USD is chosen and vice versa
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!
