cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## 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 = 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?

1 ACCEPTED SOLUTION
Super User

@joshua1990

Sure,

Here is an example file

Proud to be a Super User!

8 REPLIES 8
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())`

@joshua1990

Proud to be a Super User!

Post Prodigy

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

Super User

@joshua1990

Sure,

Here is an example file

Proud to be a Super User!

Post Prodigy

@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?

Post Prodigy

@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)

Post Prodigy

@ValtteriN THanks a lot! Any workourant without Tabular Editor? I am not allowed to use this software.

Super User

@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!

Post Prodigy

No ideas?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors