Forum Discussion
Filtering Line Charts
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
Kyle1,
Create a disconnected table as show in attached PBIX file.
Regards,
Lydia
4 Replies
Kyle1,
Create a disconnected table as show in attached PBIX file.
Regards,
LydiaSay 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?
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
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.
