Comparativo

[powerbicativa]

Boa tarde.
Eu tenho uma tabela dinâmica onde o usuário seleciona várias coleções, ex: outono 18, outono 19 e outono 20.
na tabela são exibidas informações de regiões (linhas) e das coleções (colunas), conforme abaixo:

                Outono 18 Outono 19 Outono 20
região 1
região 2
região 3
região 4

nos valores, eu tenho a venda de cada região/coleção. eu preciso é mostrar a variação entre a coleção atual e a coleção anterior. Alguém pode me ajudar?

[v-lili6-msft]

hi  @powerbicativa 

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

and for your case, I think you may need to ubpivot your datasource in edit queries

https://radacad.com/pivot-and-unpivot-with-power-bi

Regards,

Lin

[amitchandak]

these Outono 18 Outono 19 Outono 20, depends on months. Do you have data at the date level?

[powerbicativa]

no, they are codes, 201801, 201901 and 202001 respectively.

[Tad17]

Hi @powerbicativa 

Can you share the PBIX file or a screen shot of how the data is formatted?

[powerbicativa]

https://app.powerbi.com/view?r=eyJrIjoiMjJjZGEwZjctODQ2YS00MzM5LWJhYTItYWIyNDQxNjEyZDEyIiwidCI6ImJmM...

[v-lili6-msft]

hi  @powerbicativa 

what is your expected output? and if possible, could you please share your sample pbix file.

You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Lin

[powerbicativa]

of course, but I'm not able to share. can you help me?