Sum of value showing as a percentage not a true value?

[Anonymous]

Folks 

Im an absolute beginner on here and trying to self teach PowerBI via online learning. So please go easy!

I have a simple spreadsheet with 4 columns 

1. Date of month (one for each month) 

2. one for a person

3. one for a value for the month - All months have a different value! but the DATA option on the RHS shows the Value with SUM Sign in front of it? which I cant seem to change?

4. The Reason for issues for the values per month

I have import the data into PBI and have had some success presenting the data, however I am having problems with showing the value for each month?

All I seem to be able to see is each month along the Y (horizontal) axis and a 100% value for each month as the (Vertical) X axis

How can I change this from a percentage were each month shows this as 100%? To be a true value for each month ie every month has a differnt height to it in the bar charts!

[Anonymous · Accepted solution]

Hi PijushRoy

As I mentioned I am a true beginner so appologies for this!

I have done that but it still seems to only show %ages?

[Anonymous]

Here you go PijushRoy

Thanks in advance 

 

 

[PijushRoy]

Hi @Anonymous 

Please use the measure

Measure% = DIVIDE (
    SUM ( 'Sheet1'[Cost] ),
    CALCULATE ( SUM ( 'Sheet1'[Cost] ), ALL ( 'Sheet1'[Name of Month] ) )
)

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

[Anonymous]

Hi PijushRoy

Thanks for your help, I ahve tried adding the comment as suggested but this doesnt seem to change things ( appologies) I hope this is not user error, I ahve attahced screen shots of what I have done and the resulting issue.

[PijushRoy]

Hi @Anonymous 

In column bar chart, you should bring month, As you shared in your 1st screenshot.

[Anonymous · Accepted solution]

Hi PijushRoy

As I mentioned I am a true beginner so appologies for this!

I have done that but it still seems to only show %ages?

[PijushRoy · Accepted solution]

Hi @Anonymous 

Please use the measure in place of cost

and 
Name of the month in place of Data hierarchy

[Anonymous]

Again so sorry I dont quite understand 😞 

[PijushRoy]

Hi @Anonymous 

Create a sample PBIX file with data (non sensitive data), upload the pbix file in google drive and share the link quickly. GIve all access for the file.

[Anonymous]

Here you go

https://creativevehiclewrappingcouk-my.sharepoint.com/:u:/g/personal/df_creativevehiclewrapping_co_u...

[Anonymous]

Ive sent a link thanks hopefully you can access it please let me know you have it.

[Anonymous]

I have re read and followed instructions in your earlier email and now sorted it with all you help thanks very much have a rgeat weekend - Really appreciate your help

[PijushRoy]

Hi @Anonymous 

Great, Tag me if you need any help. 
Good weekend.
Appreciate your Like/Kudos

[PijushRoy]

Hi @Anonymous 

Can you please share a screenshot of your data (after removing sensitive data) and the issue you are facing?