Forum Discussion
Convert the data Round off and Decimal number on Matrix Visuallization
Hello Guys,
I want to convert the data to fixed decimal number and .1 decimal number on single count value. check the scrrenshot
There is a only one field which is decimal number datatype but I want remove that 3.0, 2.0, 3.0, 1.0 to 3, 2, 3, 1 and the 4th row need to in same format means want to remove that .0 on matrix Visuallzation.
Please let me know if any solution.
Thanks,
Pankil
Anonymous,
Add a measure as shown below.
Measure = FORMAT ( SUM ( Table1[Value] ), "General Number" )
Anonymous,
You may add an index column in Query Editor.
5 Replies
v-chuncz-msftCommunity Support
Yes I used DAX Function but can't get sucess on this.
can you please help me with the DAX function.
Thanks for you Support.
Pankil
- v-chuncz-msft
Anonymous,
Add a measure as shown below.
Measure = FORMAT ( SUM ( Table1[Value] ), "General Number" )