Forum Discussion

Icon for Post Prodigy rank

Post 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 ...

ValtteriN
3 years ago
joshua1990

Sure,

Here is an example file
Currency and volume.pbix28 KB

Icon for Community Champion rank

Community 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
Post Prodigy
3 years ago
ValtteriN THanks a lot! Any workourant without Tabular Editor? I am not allowed to use this software.
- ValtteriN
  Community Champion
  3 years ago
  joshua1990 you can also manage calculation groups in Visual studio or after the upcoming release announced at MS Build calculation groups will be available in Power BI desktop. I think this was scheduled for June's release.
joshua1990
Post Prodigy
3 years ago
ValtteriN : Thanks a lot! Could you please share the Power BI File as well?
- ValtteriN
  Community Champion
  3 years ago
  joshua1990
  
  Sure,
  
  Here is an example file
  Currency and volume.pbix28 KB
  - joshua1990
    Post 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)