Convert the data Round off and Decimal number on Matrix Visuallization

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous,

Add a measure as shown below.

Measure =
FORMAT ( SUM ( Table1[Value] ), "General Number" )

[v-chuncz-msft]

@Anonymous,

You may use FORMAT Function in DAX.

[Anonymous]

@v-chuncz-msft 

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 · Accepted solution]

@Anonymous,

Add a measure as shown below.

Measure =
FORMAT ( SUM ( Table1[Value] ), "General Number" )

[Anonymous]

@v-chuncz-msft

I tired that but I want on diffrent values not a single value.

means each row comes from single row but I want decimal values as per the row values.

are you getting my point..

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may add an index column in Query Editor.