% data vs total in funnel

[TomCuypers]

Hi There,

I have a little question. Like you see in the picture below I have made a funnel with the total amount  and one with the cost.

The light green is showing the total amount of the different countries (see total in the matrix graph below). If I select the total everything is looking good. But when I select eg Belgium in this example the amount of Belgium (16,12k) is shown as 100%. What I like to have is that the 100% is replaced by the % that Belgium is representing from the total amount (llight green).

Hopefully somebody can help me out.

Thx

Tom

[v-juanli-msft]

Hi @TomCuypers

If you just add "amount" and "cost" column to the Values field of the Funnel visual, it is not strange that the % of data doesn't show correctly.

The percent shows based on the "Group" and "Value".

Please review this article to learn how to use the Funnel chart.

Best Regards

Maggie

[v-juanli-msft]

Hi @TomCuypers

Which columns do you add to the funnel chart?

I can't see how to get the amount of Belgium (16,12k) for funnel chart in the matrix visual.

I would suggest you share an example dataset (just contains the data used in both visuals), then which columns to use in each visual.

Best Regards

Maggie

[TomCuypers]

Hi Maggie

Thx for your help, please find below the data set I used.

In my first post I just put a "count" values on the amount field to see hov many times a country recieved an amount.

Hopefully you can help me after the additional info 🙂

Thx

Tom