Forum Discussion
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 = SELECTEDVALUE('Currency/ Volume'[ID])
VAR _Volume = FORMAT(DIVIDE(SUM('Sales'[Value 1]),1000), "#,##K")
VAR _Dollar = FORMAT(DIVIDE(SUM('Sales'[Value 1 $]),1000), "$ #,##K")
RETURN
IF(_Selection = 1, _Dollar, _Volume)
I have an unrelated table with 2 columns
| Dimension | ID |
| Currency | 1 |
| Volumne | 2 |
Based on the selection of ID (1 or 2), I switch within the measure to Units or Dollars.
But now I get a Text Format as a result in the matrix. I would still like to have a number column in the matrix in the end with all values on the right alligned.
Any thoughts / optimizations on the approach above?
How would you do it?
joshua1990
Sure,
Here is an example file
8 Replies
joshua1990No ideas?
- ValtteriN
Community Champion
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
ValtteriN THanks a lot! Any workourant without Tabular Editor? I am not allowed to use this software.
- ValtteriN
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
ValtteriN : Thanks a lot! Could you please share the Power BI File as well?
- ValtteriN
joshua1990
Sure,
Here is an example file