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.
HI,
I have an Attribute Slicer for an Average.
I only wan to show Whole Numbers
Any ideas on how to do this?
Thanks in advance,
Solved! Go to Solution.
Please select the table column in the field list so it has a yellow box surrounding the field. This is just to select the field.
Then in the modelling tab on the ribbon, use the Formatting options to either convert the number to an Integer, or see if you can set the number of decimal places to 0.
One way is to set the number of decimal places in the field formatting of the column to 0
Or if you are using a DAX calculated measure to generate the average, you can wrap your formula with an INT function
Thanks, but the visual I am using does not have that option 😞
What sort of field are you using in your slicer? A calculated measure, or are you dragging a table column to the visual?
A table column
Please select the table column in the field list so it has a yellow box surrounding the field. This is just to select the field.
Then in the modelling tab on the ribbon, use the Formatting options to either convert the number to an Integer, or see if you can set the number of decimal places to 0.
awesome, thanks mate
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |