When I extracting a report from ServiceNow for instance, the percentage column shows as a number:
ServiceNow | |
Excel | ; |
To remediate, there are 2 ways, changing it from excel directly or from Power BI. I will explain first from excel, although this topic is to explain you how to do it with Power BI but in case of.
First, format the column in %, then in another column, put this formula in the cell C2:
=A2/100
Duplicate it for the other cells and format this column in % without forgetting to show 2 decimals.
For Power BI, I have to go to the query editor first:
If all go well, I get this view, so not yet the percentage I need:
To put it right:
And here it is the result:
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...