Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table that contains hundreds of numeric fields, and a lot of them are percentual values but in 0,50 format, so I need to multiplicate it by 100 always I add it to my bars, but it seems like they don´t have options like that. So I ask you if exist some options to do that, because I dont want to do a lot of measures because it will make that my program crash or go so so slow.
Solved! Go to Solution.
I end up doing it, so I will explain how if someone has a similar problem.
First, you go into Edit Query, duplicate the table in which you have the information, next you do a Text Filter in the "Crude Names" field, to only have the "Yield" information in your new table, because It is the information that we want to recalculate.
Second, you need to select all the numeric fields, and click in this option:
In this panel:
So you obtain this estructure:
The "Porcentaje" field is what i want, and it is a calculated field = "Valor" field * 100
I swear this would help someone
I end up doing it, so I will explain how if someone has a similar problem.
First, you go into Edit Query, duplicate the table in which you have the information, next you do a Text Filter in the "Crude Names" field, to only have the "Yield" information in your new table, because It is the information that we want to recalculate.
Second, you need to select all the numeric fields, and click in this option:
In this panel:
So you obtain this estructure:
The "Porcentaje" field is what i want, and it is a calculated field = "Valor" field * 100
I swear this would help someone
hi, @Anonymous
You could format calculated fields in Modeling->Formatting
Best Regards,
Lin
A lot of thanks for the help, and what you say is a good idea, but it only allows me to edit the format of the whole field, and what I need is more complex, because I have 200 fields with a crude name and 600 registers with different properties, so what I need is to see in percentual format only some of that fields, so I need a filter to say only are percentual who have in the property the word "Yield", that is so simple in programming languages but in Power BI i see it imposible unless i create 200 measures, what seems crazy and inefficient. But thanks fot the helps anyway.
hi, @Anonymous
You could filter all the fields that contains "Yield" like this:
But you need to format the fields separately, there seems to be no easy solution.
And could you please tell me if you still have other problems? If not, could you please mark the helpful replies as Answered
Best Regards,
Lin
A lot of thanks for the help again.
But You didn´t understand my problem, and its my fault because I didn´t send a screenshot of my tables, so here it goes:
So you can see that I need to modify all the crude fields, but only in the Yield registers.
And I can give you the helpful replies, but I didn´t do that because really it doesnt was a helpful replie jajaja, but I give you like in every post u post.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |