Stack bar chart visualization

[Dilantha]

I have Line stacked bar chart in powerbi desktop. 

I want to add mean line only on stack two area, Is that possible to do like that ? I added average line for both stacks, I still couldnt able to figure out how to fix that.

Thank you

[Dilantha]

I will try that, 

One other thing, can we do below steps in line and stacked column chart ?

right click on one column --> data point as table

because I cant do that in my visualiation, It an process when only remove the line.

Does that option not avalable in line and stacked column chart ? or is their any necessary steps to continue that.

Thank you 

[Icey]

Hi @Dilantha ,

Based on my test, line and stacked column chart doesn't support Data point table in Power BI currently.

You can choose to post your idea on Power BI Ideas platform.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Dilantha]

Thank you for the help. 

[amitchandak]

@Dilantha , Not very clear. Can you try Stacked Area. https://www.tutorialgateway.org/stacked-area-chart-in-power-bi/

[Dilantha]

I have stacked bar chart like this

I added line for total graph amount , but I only need mean number for yellow coloured area. Not from total values. How can I do that ?

[Ashish_Mathur]

Hi,

Share some data and show the expected result in a simple table format.

[Dilantha]

Thats the expected visualization,

If we consider thats the data table , i need to display line for only type 2 data. Is that possible to do without measure or with measure ?

can you provide measure example ?

Thank you

[Icey · Accepted solution]

Hi @Dilantha ,

Try to create a measure like below and then put it into line value field.

Measure = 
AVERAGEX ( FILTER ( ALL ( 'Table' ), 'Table'[type] = 2 ), [value] )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Dilantha]

I wanted dynamic average line, but this is worked. I changed AVERAGEX --> AVERAGE . 

It works fine.

Thank you