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.
For the data given below and the graph attached, I need a additional line graph of the summation of mobile sales in the same graph showing the brands. Please help me. I want to see how my entire mobile sales are growing and also individual brands over time on the same line graph
Type | Brand Name | Sales | Date |
Mobile | A | 1000 | Jan |
Mobile | B | 1500 | Jan |
Mobile | C | 2300 | Jan |
Mobile | D | 5000 | Jan |
Mobile | A | 1450 | Feb |
Mobile | B | 1678 | Feb |
Mobile | C | 1674 | Feb |
Mobile | D | 1683 | Feb |
try this
Total = CALCULATE(SUM(Table[Sales]), ALL(Table[Brand Name]))
If I create a total measure, how can i include that in the existing graph?
I thought that you can use multiple measures with a legend but that's not the case
you would need to remove the Brand Name from the legend, and create set of measures per Brand, e.g.
A = CALCULATE(SUM('Table'[Sales]), 'Table'[Brand Name]="A")
then you can have multiple measures in a visual, but I imagine that's lot of effort with multiple brands
I think If I add an extra custom row with the summation of the total, then,I can use it in the graph. Can you help me how can i create such custom row?
Hi @bvsaicharitha,
I'm afraid that we may not add custom rows in power bi.
Actually, I'm a little confused about your requirement.
If it is convenient, could you share your desired output so that we could help further on it?
Best Regards,
Cherry
Hi,
This is the similar output that I am interested .
Example ,the top green one is the summation of all the brand sales and the rest colors are the individual brands . Ideally, when I create the line graph, I will only get the individual ones by setting legend. I am interested to see the total as well in the same graph. Now the green graph is total of all sales over period
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |