Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Switch 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 ...
Need Help
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

Hi  ,

I would do this with a calculation group:

Expression:selectedmeasure()

Format string expression:

IF(SELECTEDVALUE('Selection for V/C'[value]="Currency", "$ #,##K", selectedmeasureformatstring())

 



 

joshua1990

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago

ValtteriN : Thanks a lot! Could you please share the Power BI File as well?

    • joshua1990's avatar
      joshua1990
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      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's avatar
      joshua1990
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      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?