Pie chart issue - a question

[Raimondas]

Hello,

I need to display amount of sales orders by quarter and a year for a customer, i managed to display them by a year, i need to display amount of sales orders for :

2020 q1,

2020 q2

2020 q3,

2020 q4,

2021 q1

as for example

how to add quarter to this situation too (showed in image????) ?

[v-shex-msft]

Hi @Raimondas,

I'd like to suggest you create a calculated column to store both year and quarter information, then you can use this on the pie chart as the category to group and summary your records.

Regards,

Xiaoxin Sheng

[NikhilKumar]

Adding the date hierarchy field and drilling down would work.

[Raimondas]

Sorry im new to PowerBI - what do you exactly mean ? add date field where ? drill down ?

[NikhilKumar · Accepted solution]

Click on the button as highlighted in the image below-