98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Formatting numbers in a visual
Formatting numbers in a visual
Resolved · Low Priority · Version 2016
Fri 23 Aug 2019, 12:11Delegate Hannah said...
Hannah has attended:
Power BI Modelling, Visualisation and Publishing course
Formatting numbers in a visual
I have been practising recreating some of the training we did. I have created a visual, a card with a single number and in the training we had the option to Format the figure in the visual e.g. to £ or with fewer decimal places but I am going to the Formatting tab and data type and Format are greyed out. Under the Format painter there is also no option to change the format of the number in the visual. How can I change it?
(Is it possible to add a screen shot in this forum as an attachment as it might be easier to see?)
Fri 23 Aug 2019, 12:39Trainer Jens said...
RE: Formatting numbers in a visual
Hi Hannah,
Thank you for the forum question.
You have 3 options to set the formatting for your numbers, but you cannot do it on visual level.
You can select the number field on the fields list in report view, and then click the modelling tab and change the formatting in the formatting group.
In data view you can select the table, click on the heading to select the column with your numbers, click the modelling tab and change the formatting in the formatting group.
You can also select the column in power query and do the formatting in power query.
If the it is a measure, you need to select the measure in report view and then click the modelling tab and change the formatting in the formatting group.
I hope this makes sense.
If you want to send a screenshot you can send it to me:
jens.bonde@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Scheduled Refresh and Power BI ServiceIf you're using Power BI Service, set up scheduled refresh for your datasets. This ensures that your reports are always up-to-date with the latest data. Understand the refresh limits imposed by Power BI Service and optimize your data model and queries to stay within those constraints. |
