% of a column over a specific total

[ElectrictEels]

Hello. I have a table "Call", that holds information about calls made to a call center. On this table, I have a field "Translation" that can either be Blank or be one of 4 values.

I have a line and stacked column chart that shows on the X axis this exact field, with the blank value filtered out:

How can I add a line that will hold, for each column, the percentage that each column represents, facing only the amount shown (the amount of calls with translation (translation not blank))?

In other words, how can I create a line that will give me the percentage that each column's amount represents in a specific amount of rows? I would like this line to still be afected by date filters. 

How can This be achieved? Thanks in advance.

What I would expect is the graph line, in this case to show 66% on ABC column and 33% on the BB column,  because I'm excluding blanks.

call_id	date	translation
1	2023-01-01	ABC
2	2023-01-14	ABC
3	2023-01-07	BB
4	2023-01-02

[v-tianyich-msft · Accepted solution]

Hi @ElectrictEels ,

The fields you need are already calculated, visual I'm not quite sure what you mean, please check:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ElectrictEels]

This is exactly what I was looking for. I downloaded your .pbix file and applied the logic to my dashboard. Works great. Thank you very much!

[Ritaf1983]

Hi @ElectrictEels 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523