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! Any workourant without Tabular Editor? I am not allowed to use this software.

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity 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.