Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
@joshua1990
Sure,
Here is an example file
Proud to be a Super User!
Hi ,
I would do this with a calculation group:
Expression:selectedmeasure()
Format string expression:
IF(SELECTEDVALUE('Selection for V/C'[value]="Currency", "$ #,##K", selectedmeasureformatstring())
Proud to be a Super User!
@joshua1990
Sure,
Here is an example file
Proud to be a Super User!
@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?
@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)
@ValtteriN THanks a lot! Any workourant without Tabular Editor? I am not allowed to use this software.
@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.
Proud to be a Super User!
No ideas?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |