Calculation items and display units

[wjess]

I am working on a matrix that utilizes a calculation group to show the actual vs forecast vs the previous week for several metrics:

I am using the Display Units dropdown under Specific Column so the actuals (Actual, Forecast, Previous Week, etc.) for specific metrics will display as Thousands but I don't want the percentages (Forecast Variance%, etc) to display in the thousands - I just want it to show a percent. 

Is there any way to have certain calculation items ignore or precede the display units or any other workarounds? 

[v-zhangti]

Hi, @wjess 

Can you provide simple pbix files for test? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

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

[DataInsights]

@wjess,

Have you tried setting the Format String Expression for each calculation item? This is done in Tabular Editor.

[wjess]

I have tried using the Format String Expression in the calculation items, but I haven't found a way to supersede the display units from the matrix.

[wjess]

My format string expressions are pretty simple currently. For the variance items, I am only using the following: 
"+0.0%;-0.0%"

[DataInsights · Accepted solution]

@wjess,

I would disable the display units and put the logic in the calculation item. For example, if you want to display an amount in thousands, in the calculation item do the following:

1. Divide the result by 1,000.

2. Use the format string expression "#,##0K".

[wjess]

I ended up doing this. Unfortunately, it makes conditional formatting a little trickier but this is the best solution.