Forum Discussion
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, ...
amitchandak
Super User
Super UserAnonymous , One is you need have date table with Month and month year and joined with your date.
You can use stacked line visual
Use Month from date sales trend as a legend.
refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
Can you share sample data and sample output in table format?
Hi Amit,
Thanks for your prompt respond.
Unfortinatelly your advice doesn't work. As I mentioned earlier, the Sales Trend data is a result of measure and it cannot be used in colums series to generate the chart.
How can I attach the data sample data here?