Filtering Line Charts

[Kyle1]

Say if I have a sample data set

Category	Bridge	Value
A	Bridge 1	2
B	Bridge 1	3
C	Bridge 2	7
B	Bridge D 1	4
C	Bridge D 2	8
B	Bridge D 2	8
C	Bridge 1	9
A	Bridge D 1	1
A	Bridge 2	3
A	Bridge D 2	5
B	Bridge 2	7
C	Bridge D 1	4

How can I make a line chart to show 2 values:

Q1 = Sum(Value where Bridge=Bridge 1)/Sum(Value where Bridge = Bridge D 1) * -1

Q2 = Sum(Value where Bridge=Bridge 2)/Sum(Value where Bridge = Bridge D 2) * -1

That is also filterable with a slicer by Category?

Currently I can make 2 calculated columns to place in a line chart, but it doesn't update with slicers.

Or I can make 2 calculated measures, but those can't be placed in a line chart

[v-yuezhe-msft · Accepted solution]

@Kyle1,

Create a disconnected table as show in attached PBIX file.

Regards,
Lydia

[Kyle1]

Say if I have a sample data set

Category	Bridge	Value
A	Bridge 1	2
B	Bridge 1	3
C	Bridge 2	7
B	Bridge D 1	4
C	Bridge D 2	8
B	Bridge D 2	8
C	Bridge 1	9
A	Bridge D 1	1
A	Bridge 2	3
A	Bridge D 2	5
B	Bridge 2	7
C	Bridge D 1	4

How can I make a line chart to show 2 values:

Q1 = Sum(Value where Bridge=Bridge 1)/Sum(Value where Bridge = Bridge D 1) * -1

Q2 = Sum(Value where Bridge=Bridge 2)/Sum(Value where Bridge = Bridge D 2) * -1

That is also filterable with a slicer by Category?

[kohlivinayak]

Hi @Kyle1

I am not sure exactly what issue you are facing, but according to the requirement you need to create a measure not a column in this case.

Second, we can add measure to a line chart.

And you are trying to plot these values against which column on the x-axis ??

Thanks

Vinayak

[Kyle1]

Hi @kohlivinayak,

Thanks for the reply. I wasn't aware that you can place more than one measure on a line chart. I would want the first measure to be named "2016 Q4" and the 2nd measure to be named "2017 Q1" on the x axis. These categorizations are not included in my dataset.