Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Can Measure Result be used for Creating a Chart?

Hi,   I have a data table as below. I used measure to calculate the Last Year Sales numbers and categorized the Sales Trend. For the Sales Trend, if this year sales is bigger than last year sales, ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your onedrive business.

 

Best Regards,

Rico Zhou

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Rico,

 

Thanks for the insights.

When I take out the country column from the table you created, the SKU list and sales numbers do not summ up. How to make it summ up, including the Sales Trend?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      tex628 Thanks for your feedback.

      But, you should  not delete the rows. In my real data, I have multiple SKUs by Countries, by Business, stc.

      I forgot to say something. If you add the total in the table, the numbers are also not correct.

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion
        6 years ago

        There might be some slight missunderstanding here.

        In your original excel chart, can you explain what exactly is being summed in the green and red parts of the chart? 

        Br,
        J