Multiple values on line chart with zero line as own value

[Tokkerashid]

Hi,

I have values for multiple brands, and I want to display all values on line chart with my own brand shown as zero line, and other brands as difference. How to display values from my brand as zero line?

[ribisht17]

I understand that you don't only want 0 line but the other lines should be the difference between the their brand and your brand 

Please use this 

Imagine that you are Central here so we can make use of above calculation to make your brand 0 and other lines are just the diff with the Central sales

Diff with Central Sales = sum(Orders[Sales])- CALCULATE(sum(Orders[Sales]),Orders[Region]="Central")

Regards,

Ritesh

Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users 

[Tahreem24]

@Tokkerashid For constant line (own brand) you can either refer my below reply OR check the Analytics Pane like below:

[Tahreem24]

@Tokkerashid Refer the below screen shot:

[Tokkerashid]

But I have a lots of brands and can't add them as separate values. 

I want to create a measure where values for my own brand is on zero line (even they are not zeros) and other brand's values as differences

[Adescrit]

You can create a measure and add it to the Values section of the line chart

Own Brand Zero = 0