Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
lastnn30
Post Patron
Post Patron

number formatting

Hi

I created a martix and i have values now in the matrix (please see below). How can I number format these values without using DAX? for example I want 1000 to be 1K or 90 to be 90.00 etc.

Thank you very much.

SNAG-0511.jpg

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @lastnn30 ,

 

If you do not want to use DAX, the only way I know if is to change the format for each column:

tomfox_0-1648235015619.png

 

tomfox_1-1648235038396.png

 

Does this help? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

Hi @lastnn30 ,

 

If you do not want to use DAX, the only way I know if is to change the format for each column:

tomfox_0-1648235015619.png

 

tomfox_1-1648235038396.png

 

Does this help? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Yes it does very much so. Thank you very much for the help. I appreciate it.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.