Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 that There's a unit corresponding my values?
I tried using concatenate, but numbers are transformed to text format, which is not ideal in my case.
Thank you!
Kind Regards,
Matt
Solved! Go to Solution.
Hi @vanquisher11,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAnother 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.
Hi @vanquisher11,
Don't know if your measures are in a single formula or using different ones, instead of concateneta you can use the FORMAT something like this:
MEASURE = FORMAT ( [Measure]; "£ ###") MEASURE = FORMAT ( [Measure]; "###") MEASURE = FORMAT ( [Measure]; "###%")
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Felix,
Thank you very much! But my measure is on one formula.. how do I use the FORMAT function if that's teh case?
thank you!
Hi @vanquisher11,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |