Forum Discussion
Line chart with overall total line
Hi, shtak
Please try the following steps:
1. Remove the use of the 'Legend' field and create separate metrics for each country and 'Toatl'
Japan line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="Japan")US line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="US")UK line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="UK")Total line = CALCULATE(Average('Table'[Share]),ALL('Table'[Country]))2. New a field Parameter (Available in latest version of PowerBI Desktop)
3. Apply the parameter to Y-axis
Best Regards,
Community Support Team _ Eason
How can I add overall total line in SSRS ?
Hi, shtak
Please try the following steps:
1. Remove the use of the 'Legend' field and create separate metrics for each country and 'Toatl'
Japan line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="Japan") US line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="US") UK line = CALCULATE(SUM('Table'[Share]),'Table'[Country]="UK") Total line = CALCULATE(Average('Table'[Share]),ALL('Table'[Country])) 2. New a field Parameter (Available in latest version of PowerBI Desktop)
3. Apply the parameter to Y-axis
Best Regards,
Community Support Team _ Eason
Hi v-easonf-msft,
Thank you for your kind reply with a latest feature.
The field parameter feature is very interesting and useful.
In some cases, the feature is available, but this time, the series are actually prducts (I took up
countries as easy examples, which lead to your solution), which change on an irregular base.
Hopefully I could avoid adding the series(field parameters).
Thanks,
Shinya
Hi, shtak
Is it convenient to provide a sample to cloud storage for further research?
Best Regards,
Community Support Team _ Eason
How can I add overall total line in SSRS ?
