% data vs total in funnel

Question

Hi There,I have a little question. Like you see in the picture below I have made a funnel with the total amount&nbsp; 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.&nbsp;Thx&nbsp;Tom

v-juanli-msft · Answer

Hi&nbsp;TomCuypers
Which columns do you add to the&nbsp;funnel chart?
I can't see how to get the amount of Belgium (16,12k) for&nbsp;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.
&nbsp;
Best Regards
Maggie

tomcuypers · Answer

Hi Maggie&nbsp;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.&nbsp;Hopefully you can help me after the additional info :)&nbsp;Thx&nbsp;Tom&nbsp;

v-juanli-msft · Answer

Hi&nbsp;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.
&nbsp;
Best Regards
Maggie

Forum Discussion

% data vs total in funnel

Related content

funnel chart

Funnel Comparision

Funnel Chart with Percent of Total

Cumulative Total

Funnel from cummulative data