100% stacked chart and line chart

[VictoriaNguyen]

Hello,

Can I able to create a 100% stacked bar graph that includes a line as well

The table below 

Many thanks 

[mahoneypat]

Yes.  You can use a line and stacked chart with a measure that shows the % of total for that category instead of the actual values (so they all add to 1).  You can add the actual values in the tooltip if needed.

Pat

[VictoriaNguyen]

@mahoneypat Thank you for your reply. 
How can I write the measure to show the percentages oftotal? I am new to Power BI 

[mahoneypat · Accepted solution]

You'll need a measure like this one.  In my case, Year is the x axis and the legend is Product Categories.  This measure is in the values (and a different measure is in the line).

Pct of Year Total =
VAR thiscategory = [Total Sales]
VAR allcategory =
    CALCULATE ( [Total Sales], REMOVEFILTERS ( 'Product'[Category] ) )
RETURN
    DIVIDE ( thiscategory, allcategory )

Pat