I need Percent difference of previous year, quarter, month. please help meeeee

[levankup777]

Example: in excel no problemExample: in excel no problemI need in this Chart

how to create? please help meeeee.

[levankup777]

my data

This is my data. Please help me with this data. Thank you in advance

[Eric_Zhang]

@levankup777
That picture doesn't help much. We have no way to copy your sample data from a picture.

To get the expected output, please reference the below steps against simple sample data.

1. Supposing the sample data has two columns(DT,QTY) as below. Create a new column Month.
   

   Month = DATE(YEAR('Table'[DT]),MONTH('Table'[DT]),1)

   
2. Create a new table 2015dataAgg
   

   2015dataAgg = SUMMARIZE(FILTER('Table',YEAR('Table'[DT])=2015),'Table'[Month],"GrpByMonValue",SUM('Table'[QTY]))

3. Create 3 columns
   

   LastMonth = DATEADD('2015dataAgg'[Month],-1,MONTH)
   LastMonthVal = CALCULATE(SUM('2015dataAgg'[GrpByMonValue]),FILTER('2015dataAgg','2015dataAgg'[Month]=EARLIER('2015dataAgg'[LastMonth])))
   Difference = IF(ISBLANK('2015dataAgg'[LastMonthVal]),BLANK(),('2015dataAgg'[GrpByMonValue]-'2015dataAgg'[LastMonthVal])/'2015dataAgg'[GrpByMonValue])

   
4. Drag a "Line and stacked column char" and select columns properly.
   

In case for any confusion, I've uploaded the pbix.

If you have any question, feel free to let me know.