Something like "Percent of Column Total" for Line Graph

[ajamess]

So I am completely new to PowerBI, I have done a tutorial and that is about it.

I have a problem I'm trying to do like this. I have sales over time for different categories and created a matrix like this.

[TABLE="width: 500"]
<tbody>[TR]
[TD]year[/TD]
[TD]2016[/TD]
[TD][/TD]
[TD]2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category
[/TD]
[TD]Sales[/TD]
[TD]% of Sales[/TD]
[TD]Sales[/TD]
[TD]% of Sales[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$500[/TD]
[TD]25%[/TD]
[TD]$800[/TD]
[TD]40%[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]$1500[/TD]
[TD]75%[/TD]
[TD]$1200[/TD]
[TD]60%[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]$2000[/TD]
[TD]100%[/TD]
[TD]$2000[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

The sales category is just summed from my data set. And I created the % of sales category by doing Quick Calc on sales, sum, "Show Value as.." Percent of Column Total.

However I would like to graph this % over time. And I can't get a quick calc of the column, only of the total (over all sales).

Thoughts on how I could do this?

 

[akice]

I think these 2 measures are what you want:

Total Sales = SUM ( Table[Sales )

% of Sales = DIVIDE ( [Total Sales] , CALCULATE ( [Total Sales], ALL( Table[Category] ) ) )