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 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

 

Tips and Tricks

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community 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
        Community 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