Forum Discussion
Need help switching Visual Views from $ to Units
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
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/
2 Replies
vicky_Super User
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/
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.