formatting numbers visual

TrustPilot

starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Formatting numbers in a visual

Formatting numbers in a visual

· Low Priority · Version 2016

Fri 23 Aug 2019, 12:11 replyReply Delegate Hannah said...

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?)

For upcoming training course dates see: Pricing & availability

Fri 23 Aug 2019, 12:39 replyReply Trainer 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: 0845 5194 797
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

 

Live dates & prices

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power bi tip:


TrustPilot
TrustScore 4.9 / 5       1106 reviews