Line (in line and clustered column chart) shown as one dot instead of a complete line

[hvchuatico]

Hi, I'm trying to show a complete line of the different values of Mortality Rate in this chart but for some reason it shows the summation and not the different values. Is there something I'm doing wrong?

As you can see the blue dot there it just shows the sum of mortality rate. I need it to be a complete line so the person may be able to see the relationship between the y-axis values and the x-axis values. Thank you!

[V-lianl-msft]

Hi @hvchuatico ,

Is this problem sloved?
If not, please let me know.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-lianl-msft · Accepted solution]

Hi @hvchuatico ,

Unfortunately, your needs cannot be fully met.

You can refer to the following steps:

1.Put "country" in "shared axis".

2.Enter start and end values to match the primary axis or turn off the "show secondary"

3. Use measure to set the data color for each country

Measure = SWITCH(MAX(Sheet4[Country]),"Sweden","#FF9F33","Denmark","#FF4F33","Norway","#33DAFF")

For more details,you can refer to the pbix.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Check this. How to display analytics lines

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

[hvchuatico]

Thanks for replying! But the analytics line just is the average. I have different values for the line chart, not just the average. It used to work in my past Power BIs but for some reason it isn't working here.

[PaulDBrown]

@hvchuatico 

can you provide some sample data?

[hvchuatico]

Sure! Like for example: 

Country	Women in National Parliament (%)	Mortality Rate
Sweden	44	7
Denmark	34	9
Norway	32	6

I want the women in national parliament to be a bar chart, then a line chart for the mortality rate so that they'll be able to see the relationship between the two. I hope that's fine. 

[PaulDBrown]

@hvchuatico 

Evening,

Not sure what may be the problem. I just imported the data, created sum measures (works the same with averages), placed a "Line and stacked column chart" on the page, added the SUM of Women in Parliament to the "Column Values", the SUM of Mortality Rate to the "Line Values" and country as x-axis and got this:

EDIT: Actually, seeing the title of your post, the problem might be that you are using a "Line and clustered column chart"?