Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous,
Add a measure as shown below.
Measure = FORMAT ( SUM ( Table1[Value] ), "General Number" )
@Anonymous,
You may add an index column in Query Editor.
@Anonymous,
You may use FORMAT Function in DAX.
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
@Anonymous,
Add a measure as shown below.
Measure = FORMAT ( SUM ( Table1[Value] ), "General Number" )
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..
@Anonymous,
You may add an index column in Query Editor.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |