Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Below is a snag of a chart that's displaying numbers to the E-n and I don't want it to. Those numbers are measures. If they weren't, I could change the data type to fixed decimal, 2 decimal places, and it would display the numbers as 0.00.
Does anyone know if it's possible to change the data type of a measure to fixed decimal via DAX since we're not able to change the data type via the modeling tab?
HI @bchager6,
Can you please share some dummy data with a similar data structure? It will help for test and coding formula on them.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Can this help
https://docs.microsoft.com/en-us/dax/fixed-function-dax
https://www.youtube.com/watch?v=Z9HNYx-b7ro
Neither of these help unfortunately. The FIXED function changes the data format to text.
I don't know if that solves the problem but you could change the measure datatype .
Unders Report tab,
If you are using latest desktop with new ribbon preview, when you click on a measure a "Measure tools" menu appears and you could change the data type and no. of decimals.
Please see the image for old design.
If this helps, mark it as a solution
Kudos are nice too.
This doesn't work unfortunately. As I noted originally, we are unable to change the data type of a measure within the modeling tab or within the measure tools.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |