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.
Hello,
I am trying satcked bar chart with line of all brands.
But i can only select column series and put my brands in stacked bar for that month.
But for Line chart I get an average of the all brands for that month. I don't get any indivual line of brands for that month with the stacked bar.
Any help would be appreciated.
Solved! Go to Solution.
Hi @rajatamin18,
There is no Line Series property in line and stacked column charts. If we want to plot more than one lines to display value for each column series, we need to create corresponding number of measures to calculate value for each series. And place those measures in Line Values.
Best Regards,
Qiuyun Yu
Hi @rajatamin18,
There is no Line Series property in line and stacked column charts. If we want to plot more than one lines to display value for each column series, we need to create corresponding number of measures to calculate value for each series. And place those measures in Line Values.
Best Regards,
Qiuyun Yu
Whaaaaat. I could swear I've tried to do that before and it didn't work. Apparently not. Thanks for the correction @v-qiuyu-msft
Proud to be a Super User!
@rajatamin18 If I understood you correctly what you need to do is create measure that gives you average of individual brands and then drop those measure fields into Line values section of the visual. That way you will get multiple lines, one for each brand.
Hi @ankitpatira,
As per your solution I can get it in the line chart.
But I want all brands trend line as well as all brands stacked in the same charts.
Using the line and stacked chart.
@rajatamin18 the stacked bar and line chart cannot display multiple lines.
Proud to be a Super User!
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |