Pareto chart does not change the order of categories

[leoohenrii]

I created a pareto chart using DAX. At first it is working normally.

The only problem I'm having is that when I select a filter, the line in percentage does not respect the Pareto principle.

I am attaching a print of the problem and the code in DAX.

Link dataset = https://drive.google.com/file/d/1qK1okpRjsXKCgJ0Rk08cZloT2oCcEXq6/view?usp=share_link

DAX Code: 

//Total Invoicing

Faturamento = SUM(e_commerce_brasil[valor_pago])

//Pareto 

Pareto Faturamento =

VAR tFaturamento = CALCULATE([Faturamento],ALLSELECTED(e_commerce_brasil))

VAR fAtual = [Faturamento]

VAR tbResumo =

    SUMMARIZE(ALLSELECTED(e_commerce_brasil), e_commerce_brasil[produto_categoria], "Total", [Faturamento])

VAR tAcumulado =  SUMX(FILTER(tbResumo, [Total] >= fAtual), [Total])

RETURN

tAcumulado / tFaturamento

-------------------------------------------------------------------------------------------------

How to fix? 

No Filter

With filter

Thx 😁

[ppm1 · Accepted solution]

Looks like you are cross highlighting and not filtering. You can change the behavior between visuals with the Edit Interactions feature.

Change how visuals interact in a report - Power BI | Microsoft Learn

Pat

[leoohenrii]

Exactly!

I knew from the beginning, I was testing the guys haha!

Joking aside, thank you, it really was a lack of attention.