Forum Discussion
Calculate Percentage on values
Hi,
I need a help on calculating % Percentual values from some data filtered into Ballons Options from an excel file (as database)
Is there anyway to include bellot % of the grand total (Total Facutrado).
Thanks
4 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
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 Hi,
I have a formula that groups the amount that i show on grafics like this
I want to have percentages of each group of the total sum amount.
Thanks
- lbendlin
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216Screenshots are not helpful.
Hi,
This is how values are grouped
ConceptoFecha de documentoVencimiento netoDemora tras vencimiento netoCategoria de VencimientoImporte en moneda doc.Moneda del documento
Concept
Document Date Due Date Due Days Ageing Amount USD Demora
1/10/2019 1/10/2019 1.102 (6) +181 DAYS 90,00 USD Demora 13/11/2019 13/11/2019 1.059 (6) +181 DAYS 45,00 USD Flete / Manifestado 28/11/2019 28/11/2019 1.044 (6) +181 DAYS 300,00 USD Flete / Manifestado 28/11/2019 28/11/2019 1.044 (6) +181 DAYS 300,00 USD Flete / Manifestado 18/12/2019 18/12/2019 1.024 (6) +181 DAYS 300,00 USD Flete / Manifestado 18/12/2019 18/12/2019 1.024 (6) +181 DAYS 300,00 USD Highlighted are the groups that i show on Report.
Hope this helps.
Thanks
