Forum Discussion
joshua1990
Post Prodigy
Post ProdigySwitch between Currency and Number
Hi all!
I have a report where I would like to put a switch on top as a slicer to switch between currency and units.
For this objective I started with this approach:
SWITCH A =
VAR _Selection ...
joshua1990
Sure,
Here is an example file
joshua1990Post Prodigy
Post ProdigyValtteriN : Thanks a lot! Could you please share the Power BI File as well?
ValtteriN
Community Champion
Community Championjoshua1990
Sure,
Here is an example file
- joshua1990
ValtteriN : Thanks a lot for providing this. It seems like the same column is display once in units and once in dollars, right?
But what I need is something the also multiplies the units into a dollar value. I have a column with units, I have a column with the price per unit and then if needed I have a calculated column with the total dollars (units x price)
- joshua1990
ValtteriN :Thanks for sharing. Is it possible to use the same approach to switch between a Volume and a Dollar column with the indidivudal format? As of now it changing just the format for a single column, right?