Reply
New Member
Posts: 1
Registered: ‎08-23-2016
Accepted Solution

Showing total sales vale per month

I am newbie to PowerBi, but I have managed to get the data into powerbi through a web data source. The data imported was in json format and its been now formatted into table columns.

 

The data which I have imported have the sales details. that includes a column for sale date and sale amount. I would need to show a monthly sale report, which shows a bar graph with total sales amount for each month.

 

So what i Have done as far is, i dragged the sale date from the fields into the report panel, and then dragged the sale amount into column vales. I can see a graph, but it shows the total count rather than the sum. how do i achieve the sum?


Accepted Solutions
Member
Posts: 65
Registered: ‎06-25-2015

Re: Showing total sales vale per month

Hi, you can create a meassure and just create the aggregation YourMeassure = SUM(YourTable[YourColumn])

 

Then add your new meassure to your chart.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co

View solution in original post

Super Contributor
Posts: 895
Registered: ‎06-09-2016

Re: Showing total sales vale per month

Hi

 

You need to change your data type Decimal Numbers for Sales amount to be able to see the sum of the values. Text data types create the count of the transactions.

 

It would be better if you use explicit measure rather than implicit.

 

Right click on your table and select create new measure

 

Give suitable name to your measure and write this formula

 

mymeasure:=SUM(Table1[Sales Amount])

 

Hope this will solve your problem. Let me know if confused.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post


All Replies
Member
Posts: 65
Registered: ‎06-25-2015

Re: Showing total sales vale per month

Hi, you can create a meassure and just create the aggregation YourMeassure = SUM(YourTable[YourColumn])

 

Then add your new meassure to your chart.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co
Super Contributor
Posts: 895
Registered: ‎06-09-2016

Re: Showing total sales vale per month

Hi

 

You need to change your data type Decimal Numbers for Sales amount to be able to see the sum of the values. Text data types create the count of the transactions.

 

It would be better if you use explicit measure rather than implicit.

 

Right click on your table and select create new measure

 

Give suitable name to your measure and write this formula

 

mymeasure:=SUM(Table1[Sales Amount])

 

Hope this will solve your problem. Let me know if confused.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎08-23-2016

Re: Showing total sales vale per month

[ Edited ]

You can click on the arrow at the Value field and select Sum. And for th chart, you can use a Stacked Column Chart, and you need to drag and place your Date field into the Axis field of the chart, and your Sales Amount field into the Values field. Then, you can drill down/up the data within the chart, to show it as Year, Month, etc.