Is there a way to get rid of the decimal point in an Whole Number column, where the average is calculated using the Visualisations pane?
I could add a measure sales (avg) = AVERAGE([Sales]) and format it as Whole Number, however I am trying to avoid adding more measures.
You should be able to go to the Format tab -> Data labels, and set Decimal Places to 0 for that visual, then the average value should be shown as whole number without the decimal point.
What about card visualisations - it doesn't have that option.
I'm averaging a series of whole numbers and displaying in a card visual and want to get rid of the decimal places. Why is the default to have decimals in the first place for an average - doesn't make sense to display an average with decimal places in the first place.
This should not be this difficult!
You should click on the spacific column before you go to the modeling tab, then you will be to remove the decimal point or to change to column type
The value shown on the bar graph should be changed to whole number by using the solution I mentioned above.
However, there is currently no options to change the data label format for the value or the tooltip shown up when hovering over on the bar graph. You can vote the idea here.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.