Forum Discussion
Bar Graphic or Table with calculated fields
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.
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:smileywink:
5 Replies
v-lili6-msftCommunity Support
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.
- v-lili6-msft
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 :smileyvery-happy:
Best Regards,
Lin
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:smileywink: