Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculation items and display units

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? 

Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Anonymous,

     

    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".

6 Replies

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    4 years ago

    Anonymous,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

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

         

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    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.