Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I used below dax for formatting the QTY values.
Select the measure in the right overview of tables, then go to tab Modelling and change the data type. In the below example i've selected 'UserID' and the data is shown as type Text.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
@Anonymous ,
Try to change the Data Type of New QTY from Modelling tab to "Decimal".
Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!
With my dax - im converting 'my numbers into the following format
10.10
10
1
that is the main requirement to fulfil but with this dax number convert to text itself
so I need to get it only number format with mention requirement
Hi @Anonymous ,
Do the answers make sense? If so, kindly accept the helpful answers as the solutions to close the case please. More people will benefit from here. Thanks in advance.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
It is caused by the function of FORMAT which converts a value to text according to the specified format. You could show the values with the formula "New Qty". But if you want to calculate, you could use the original column. For now, there is not a good idea to get conditional formatted numbers directly. You could vote the ideas up to get the feature fixed quickly.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18003598-number-formatting
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |