Forum Discussion
Helper IILine 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 following is the Excel image.
1. Country series and overall total share.
2. US trend with Total line (Total share is for all the countries which are same values as No.1)
How can I create the PowerBI report as above?
I have an idea that
add records with "total" country to the existing datasource (which is for each country)
and
specifiy the datasource on Line chart as if the "total" is one of the countries.
The datasource could be confusing, I would ask you for any better ideas.
Best regards,
Shinya
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
