Forum Discussion
Converting Field to Percentage
Hello! I am new to Power BI so this should be an easy one for you guys! I have a spreadsheet that I update manually for my team and I imported that into Power BI. I calculate a % of change from one sprint total velocity to another - I want to know the change by sprint. See below screenshot.
In BI, that field is a uncategorized. See next two screen shots.
Data categoryField values
I read somewhere that in BI, you can't have the formula calculating each cell (I am not explaining that right). For example, my formula for caluclating this field in excel was =([Velocity L7-Velocity L6)/Velocity L7. Can I do that in BI?
When I pull the data into a chart, it isn't useful. I would like it to be a percentage and I can add conditional formatting.
Is there a way I can add a column or measure to convert my percent of change to a percentage? Or is there a better way to calcluate this in BI?
Thank you!
PS: I will be updating the excel spreadsheet bi weekly and refreshing my BI.
data type optionspercent formatting is grayed out
Anonymous
One is the data type > decimal number, the other is the format of that data > percent
If you set the data type to decimal number then you will be able to click on the % button to format it.
6 Replies
- jdbuchanan71Super User
Hello Anonymous
You want to be changing the Data type rather than the Data Category:
- AnonymousNot applicable
I tried that, but all it says is decimal number, fixed decimal, whole number, date/time, date, time, text, true/false.
- jdbuchanan71Super User
Anonymous
One is the data type > decimal number, the other is the format of that data > percent
If you set the data type to decimal number then you will be able to click on the % button to format it.
- Greg_DecklerCommunity Champion
Select the column and then from the Modeling tab, choose the % icon.
- AnonymousNot applicable
I tried that as well.... the percentage button is greyed out.