Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Line and clusterd colum chart

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 l...
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Hi Lin,

I transposed as below then was able to achive the chart

 

 

 

 

 

 

 

 

Regards,

Samuel

 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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