Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Adding Units

I want to add a unit on each of my values   Desired Table Measure 1     Values  Profits          £500 Sales              30000 EBITDA          90%     How do I create a column/measure such t...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    You use exactly as a column:

     

    Formated measure = FORMAT (SUM(Table[Column]), "### €")

    You can do it as I place it on top calculating your measure or make a new one and use the first measure on your syntax.

     

    Regards,

    Mfelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Another solution would be to format your visual as a MATRIX, and then in the values section of the formatting options, check the box for "Put Measures on Rows".

 

That way you can put your 3 individual measures in the visual, and all of them can have their own formatting, as determined in the modeling tab.