Line and clusterd colum chart

[Anonymous]

Hi All,

Need help in creating a chart Line and clusterd colum chart on Product vs Monthly sales with data below.

Example product (coffe) in Y axis and sales per month in Y axis and line value as 60% threshold.

like below.

I triedwith  shared axis months and colum values country and line Value (a seprate table with threshold value as 60% for all months)

i colum values for country i get only count and count distint but not the actual values in dataset.

Regards,

Samuel

[v-lili6-msft]

hi @Anonymous 

For [country] column must be text format, it can only be First/Last or Count/Count(Distinct).

You should use other Numeric columns in the column value instead of country column.

If you still have problem, please share a simple sample pbix file and your expected output.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[Anonymous]

Hi Lin,

I transposed as below then was able to achive the chart

Regards,

Samuel

[v-lili6-msft]

hi @Anonymous 

---

@Anonymous wrote:

Hi Lin,

I transposed as below then was able to achive the chart

Regards,

Samuel

---

It's pleasant that your problem has been solved, 😁 could you please mark the reply as Answered? that way, other community members will easily find the solution when they get same issue.

Regards,

Lin