Edit the line and legend on a line cluster column chart

[Galoyol84]

Hello Community I need your help with this:

I want to use a line cluster column chart to represent  the results of an indicator for five countries and the world. The bars would show the level for every country and the line would show the indicator for the world.

I have the following and would like to edit 3 things (highlighted in red)

1.- Is it possible to edit the legend to remove the light blue for Results # and just leave the dark blue for World Adolescent Fertility rate?

2.- Is it possible to remove the data legend for World Adolescent Fertility rate, it is shown 5 times and I only need it once?

3.- Is it popsible to extend the line as shown by the red arrow?

Any help is appreciated, 

Tanks

PS I include a pbix file as an example  of what I have

https://drive.google.com/file/d/1Ljbnt41grgm32wyHgE-70LWDi6eq7UO0/view?usp=sharing

[v-lili6-msft]

Hello @Galoyol84

For your need, 1 and 3 could not be achieved in power bi for now.

for 2, you could adjust the [World Adolescent Fertility Rate] measure as shown below:

World Adolescent Fertility Rate = IF( RANKX(ALLSELECTED(FactCountryIndicator[Country]),CALCULATE(SUM(FactCountryIndicator[Result (#)])))=1,43)

Result:

Best regards

Lin

[v-lili6-msft · Accepted solution]

hi  @Galoyol84 

For your requirement, 1 and 3 could not be achieved in power bi for now.

for 2, you could adjust the measure [World Adolescent Fertility Rate] as below:

World Adolescent Fertility Rate = IF( RANKX(ALLSELECTED(FactCountryIndicator[Country]),CALCULATE(SUM(FactCountryIndicator[Result (#)])))=1,43)

Result:

Regards,

Lin

[mahoneypat]

I don't think you can do 1 and 3, but for #2, you could not show data labels for the line (Data Labels area/Customize Series) and (if the values are always the same) add a card visual next to the visual also with that measure.  To get all you want, you may need try other visuals from AppSource or even build you own visual with Charticulator.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat