Align text in dax measure (power pivot)

[Sudbrl]

Dear Sir 

I have created measures and Pivot Table Slicer where the user can choose measure from the slicer dynamically in the same column, the problem here is

can I justify (align) each measure as per my choice by adding some line code inside the respective measure ?

Centre: for measure with number output

Largest Amt  (By Balance)

70,000,000.00

156,016,735.80

137,727,676.84

17,596,390.93

Left: For measure with Text output

Largest  Client Name

Ram Co

Shyam Co

Hari Co

Immanuyal Inc

[v-yangliu-msft]

Hi  @Sudbrl ,

I created some data:

Here are the steps you can follow：

1. Modeling – New parameter – Fields – select [Balance] and [Largest].

2. Place the [Parameter] of the Parameter Table in Visual.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Sudbrl]

Dear Yang

Thank you for your reply. I am trying to do the same in excel using power pivot and it is for an official dashboard.

Due to an alignment problem, the report does not looks neat. Can it be done on excel itself ?

[Sudbrl]

@tamerj1 @Greg_Deckler