Forum Discussion

shtak's avatar
shtak
Helper II
4 years ago
Solved

Line chart with overall total line

Hi all,   I'm creating a line chart with   distinct series(country sales share)   and   a total line which depicts the share for all the countries whichever countries are filtered   The follow...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    How can I add overall total line in SSRS ?

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How can I add overall total line in SSRS ?