Forum Discussion
Dynamically changing measure based on selection.
Hi All,
I have 2 columns, Local currency sales, and foreign currency sales. I want to have a selection box (Local / Foreign) and based on that, display all sales across the app off that selection.
Can you please advise how to accomplish this.
Thanks,
Wynand
HI WynandCilliers,
I think you can take a look at the following blog to use the switch function and measure name to achieve dynamic change display values:
Regards,
Xiaoxin Sheng
2 Replies
WynandCilliers , I think you need measure slicer
measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEHI WynandCilliers,
I think you can take a look at the following blog to use the switch function and measure name to achieve dynamic change display values:
Regards,
Xiaoxin Sheng
