Pie chart display values by quarter and month

[marial16]

Hallo,

i would like to create a few pie charts.

these should display the number of Orders by Reasons for  specific Months and the average of 2 first quarters.

The SP list i use to get the data has a Date column (i transformed it as date) and added a new column to get the month number only.

Another column has the reason and there is also the OrderNo (which is a code of each Order).

I tried to add 4 pie charts but the values i get are wrong.

Any ideas?

[amitchandak]

@marial16 , Cre a date/calendar Table, join that with date of your table and use month and qtr from date table into pie visual

Calendar = Addcolumns(calendar(date(2020,01,01), date(2021,12,31) ), "Month no" , month([date])
, "Year", year([date])
, "Month Year", format([date],"mmm-yyyy")
, "Month year sort", year([date])*100 + month([date])
, "Qtr Year", format([date],"yyyy-\QQ")
, "Qtr", quarter([date])
, "Month",FORMAT([Date],"mmmm")
, "Month sort", month([DAte])
, "Is Today" ,if([Date]=TODAY(),"Today",[Date]&"")
, "Month Type", Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY") )
,"Year Type" , Switch( True(),
year([Date])= year(Today()),"This Year" ,
year([Date])= year(Today())-1,"Last Year" ,
Format([Date],"YYYY")
)
)