Line and Clustered column chart

[Anonymous]

My dataset is as follows:

My chart displays data as follows:

The line chart which is ratio displays by YEar and not by month.

Can someone please help?

[v-eqin-msft]

Hi @Anonymous ,

Sorry,but I'm not very clear about your requirement...Maybe you want to use a hierarchy on the X-axis?

In addition,I noted that the value in Month of "September" is misspelled in your data sample.

After corrected it, you could use the following formula to create a new column and then set the data type as "Date",then format it as "Month year(mmmm,yyyy)". So that you could use this column as X-axis and use a date hierarchy like this:

Is the result what you want? If not, please upload some detailed data samples and expected output.
Please do mask sensitive data before uploading.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi Evelyn,

This does not solve my solution. 

The graph I have is drawn in Python, I'll upload some screenshots

[v-eqin-msft]

Hi @Anonymous ,

According to my understanding, you want to  use both year and month as X-axis, right?

For my test, you can add a new column to  bound year and month using the following formula:

year-month = 'Line and Clusted'[Year]&"-"&'Line and Clusted'[Month]

My visualizations look like this:

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @v-eqin-msft ,

Can I get Year+Month to display as YEar?

ara

[v-eqin-msft]

Hi  @Anonymous ,

Because in your data sample, the value of Year is assigned to the Month column.

After exchange the two column name，the visualization will be right:

Is the result what you want? If not, please upload some data samples and expected output.
Please do mask sensitive data before uploading.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @v-eqin-msft ,

Thank you for your reply..

When I correct that, my line column shows Yearly ratio and notYearly and Monthly.

I want the line to be displayed by Year and Month

Thanks,

ara

[amitchandak]

@Anonymous , I can see the year as legend and Month as the axis . How was it expected

https://data-flair.training/blogs/power-bi-combo-chart/

[Anonymous]

@amitchandak 

The line currently shows yearly ratio and not yearly and monthly ratio ( which is what I want)

[amitchandak]

@Anonymous , if mean line. As of now, line will not follow the legend, Please log and idea.