Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I present some data in a matrix visual. Within this visual, units are displayed in K€.
I am trying to hide the K€ units while maintaining my value in K€. It would clarify the table which is already a bit heavy with multiple columns...
Is it possible in Power BI ?
Of course there is a workaround, which is divinding my figures by 1000 but it does not seem to be a best practice 🙂
Thanks for your precious insights !
Benjamin
hi, @Anonymous
See Display units and precision control for table & matrix columns in Power BI Desktop
Or you could use FORMAT Function to custom the format of it.
Best Regards,
Lin
Hi @v-lili6-msft ,
Thanks for replying.
This option does not seem to be available in Power BI according to your link and some further documentation I read.
I assume that using the FORMAT function requires to custom any values displayed on the matrix table...
Best regards,
Benjamin
hi, @Anonymous
Update your power bi desktop to the latest version.
Use Format function to custom any values is also a great way.
Best Regards,
Lin
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |