Creating a Bar chart where its value is the difference between the two lines already on chart

Question

Hi&nbsp;&nbsp;I have some data which I have already put into a chart. The lines are completely independent and I have 2 sets of filters which control them respectively (I have attached the data and the dashboard)&nbsp;I want to create a bar chart that shows the difference between the values of the two lines. Can't seem to get it to work? Ideally on the same chart or on a seperate chart works as well!&nbsp;Thanks&nbsp;&nbsp;Datahttps://docs.google.com/spreadsheets/d/14JwRvhuriWSnXynf0rB_hycxCP5q95Qb/edit?usp=sharing&amp;ouid=106675497248831812158&amp;rtpof=true&amp;sd=trueDashboardhttps://drive.google.com/file/d/1Ko3nPOIWfM8M6HGOfFTiOI8tRp9J-Ggi/view?usp=sharing

selimovd · Accepted Answer

Hey&nbsp;kash123&nbsp;,&nbsp;you can add a measure that is calculating the difference:Diff Sales Curves = SUM( 'Table Curve 1'[Sales (Millions)] ) - SUM( 'Table Curve 2'[Sales (Millions)] )&nbsp;This measure you can then put into a bar chart as you wanted:&nbsp;Or for example in a Line and Stacked Column Chart:&nbsp;If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍&nbsp;Best regardsDenis&nbsp;Blog: WhatTheFact.biFollow me: twitter.com/DenSelimovic

Forum Discussion

Creating a Bar chart where its value is the difference between the two lines already on chart

2 Replies

Related content

How to avoid people creating multiple times the same table in different workspaces

Different schema into different destination

Create a report per Worker ID with different datasets feeding different tablix

Creating relationships

Creating ICMs via Activator