cancel
Showing results for
Did you mean:
Frequent Visitor

How to get percentage from multiple different rows

Hi

I have 4 different  column values that come from table. Each value must be Sum and percentage and last one total of them all

Below is example where 101 = sum(tablename.column2) is 100% and then 33 = sum(tablename.column3) is 32%, 23 is 22% and so on

With these values i need to make a graph. Do i need to write some kind of measure, where it would take 4 different sum values of  then change them to needed percentage or is there another way?

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

Re: How to get percentage from multiple different rows

• In Dispute vs CurrentAmount (%)
• In Collection vs CurrentAmount (%)
• VIPRecieivables vs CurrentAmount (%)
• Overdue vs CurrentAmount (%)

Hard to explain, but like before i said, CurrentAmount is Total

Edit. I found a solution to my problem. I used marketplace and installed custom gauge, that does the trick

4 REPLIES 4
Highlighted
Super User

Re: How to get percentage from multiple different rows

Depends on what you want your graph to be, can you provide an example?

I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Frequent Visitor

Re: How to get percentage from multiple different rows

I dont really have a specific graph in mind. As long as it shows the right percentage. I tried with stacked column graph

Test file:

JanCurrentAmount is the total and current, totaloverdue, indispute, incollection are then part of it.

Community Support Team

Re: How to get percentage from multiple different rows

Hi @annika29 ,

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Frequent Visitor

Re: How to get percentage from multiple different rows

• In Dispute vs CurrentAmount (%)
• In Collection vs CurrentAmount (%)
• VIPRecieivables vs CurrentAmount (%)
• Overdue vs CurrentAmount (%)

Hard to explain, but like before i said, CurrentAmount is Total

Edit. I found a solution to my problem. I used marketplace and installed custom gauge, that does the trick

Announcements

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Get your latest community news and announcements.

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 153 members 1,871 guests
Recent signins: