Need help switching Visual Views from $ to Units

[Anonymous]

I have a Power BI Report with 25 Retailers.

I have a filter in the top to select retailer and channel (online vs store)

I would like to be able to add a filter that switches between "Units" or "USD", but I'm not sure exactly how do to that with my existing measures. 

I tried adding a Bookmark button for "Units" and "Dollars", but it doesn't work with the filter as it resets the account selected everytime I click the Bookmark Button.

Any advice is appreciated. Below is the dropbox link for my sample excel files and PBIX.

https://www.dropbox.com/scl/fo/gwdkwyh60gxfh4n0str79/h?dl=0&rlkey=dua44gaaiyvf7apzx74ql05ix

Below are a few of the unit metrics I would like to be able to switch to in the table visual. For the Graph visual, I would like to be able to toggle between POS Units and POS Value USD

[vicky_ · Accepted solution]

You can try solve this using field parameters to toggle between the various measures you have. Here's a tutorial on that: https://www.sqlbi.com/articles/fields-parameters-in-power-bi/

[Anonymous]

Hi Vicky, that was extremely helpful advice!

I added each column as a parameter, would there be a way to combined all of these into a "$" or "Units" parameter, rather than having to select 5 parameters for $ and another 5 for Units?

I have a filter for each parameter "Units" and "Dollars". The issue is, there isn't an option to just select none, so the table displays at least one Unit and Dollar parameter. I just need it to display all of the Unit parameters or all the $ parameters.