- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Percentage value not showing as percentage
Hello Everyone,
I'm fetching data in Power BI Desktop from a sharepoint excel file
As you can see we have multiple values in Particulars which are integers but for ROE the value is in percentage,
When I'm putting the fields in a matrix visual it's giving integer values for ROE too which is not the requirement,
The output I want should look like this
And in Power bi it is looking like this
Any work around or solution to what I want to acheive?
Any efforts or support will be appreciated.
Thank You All.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Check the column format dropdown under the Column Tools tab. Even if its a percentage type, it can still be formatted in different ways and it's probably defaulting to not showing the percent sign.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Actually the column 'Amount' has values as integers but for a ROE Particulars the values in Amount is in percentage, if I'll change the format of the column then for every Particulars the value will come in %but I just want to display the % value for ROE Particulars.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You really shouldn't have them both in the same column if they're not the same data type. I don't know if you have any control over the data source structure, but if the screenshot is the actual source, that's not really the type of thing that Power BI wants to work with - it wants the flat line-item level data and it wants to summarize it for you. There's not a lot of point to putting it in PBI if it's already summarized like that--

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-09-2024 11:36 PM | |||
05-07-2024 10:14 PM | |||
01-15-2024 03:46 AM | |||
10-29-2024 09:52 AM | |||
06-20-2024 12:45 PM |
User | Count |
---|---|
137 | |
107 | |
84 | |
60 | |
46 |