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.
Hi,
I am using Power BI desktop and would like to show the line value for each column series ( severity ). I created a Quick measure for totals and used that for creating line values.
My table has column to calculate whether each defect is over target or under target depending on the cycletime.
Solved! Go to Solution.
Hi @belurrashmi,
From below image, we can see the legend in a line chart can divide a line into several series based on legend items. However, the legend in a combination chart seems doesn't work, because it only applies to column bars in a combination chart.
To work around that, you should create multiple measures to generate multiple lines based on different legend items.
Count over High = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "High" && 'Line chart'[Target] = "Over Target" ) ) Count over Low = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "Low" && 'Line chart'[Target] = "Over Target" ) ) Count over Medium = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "Medium" && 'Line chart'[Target] = "Over Target" ) )
Besides, you can submit a feature request on idea.
Best regards,
Yuliana Gu
Hi @belurrashmi,
From below image, we can see the legend in a line chart can divide a line into several series based on legend items. However, the legend in a combination chart seems doesn't work, because it only applies to column bars in a combination chart.
To work around that, you should create multiple measures to generate multiple lines based on different legend items.
Count over High = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "High" && 'Line chart'[Target] = "Over Target" ) ) Count over Low = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "Low" && 'Line chart'[Target] = "Over Target" ) ) Count over Medium = CALCULATE ( COUNT ( 'Line chart'[Target] ), FILTER ( 'Line chart', 'Line chart'[Level] = "Medium" && 'Line chart'[Target] = "Over Target" ) )
Besides, you can submit a feature request on idea.
Best regards,
Yuliana Gu
Would you be able to start the line values according to the lenger. For example show the line values Count of HIGH from the column Level HIGH and similarly the line Count of Medium originate from the column Medium. At the moment it seem to be originating from the middle of the column
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |