Aligning numbers (in text) to the right side of column in matrix (within measure)

[Anonymous]

Dear community members,

I am seeking your support for the following:

I have a written an extensive measure  (below more details) with a formatting solution included. The result is that values shown in the columns in the matrix are positioned on the left side, where I want to show them on the right side. How could I adapt?

Example:

1 Slicer Measure Select =

2 SWITCH( SELECTEDVALUE(Tbl_SlicerMeasure[Measures]),

3 "Budget sales/ m2 (in €)", FORMAT([Budget sales/ m2 (in €)],"€ #,##0.00"),

4 "Actual sales / m2 (in €)", FORMAT([Actual sales / m2 (in €)],"€ #,##0.00"),

5 "Diff Sales / m2 (in €)", FORMAT([Diff sales / m2 (in €)],"€ #,##0.00"),

6 "Diff Sales per m2 (in %)", FORMAT([Diff sales per m2 (in %)],"#,#0.0"),

7 blank())

Thanks in advance!

[Anonymous]

Thanks for your reply Jihwan Kim.

No, I mean to show the value itself to the right side of the column in the measure.  Pleasse find below an example:

Thanks in advance for any suggestion.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try to change the setting by going into the formatting pane -> field formatting section (Similar location to the below picture).

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

Perfect! It works!  Thanks a lot!

[Jihwan_Kim]

Hi, @Anonymous 

Please correct me if I wrongly understood your question.

Do you want to show the currency symbol located on the right side of the number?

Please try to replace like below.

"#,##0.00 €"

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/