Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Kyle1,
Create a disconnected table as show in attached PBIX file.
Regards,
Lydia
@Kyle1,
Create a disconnected table as show in attached PBIX file.
Regards,
Lydia
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |