cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sekinod
Helper II
Helper II

Categories Values As Per the Installment payment

I have data table as below

 

loan.JPG

 

Table contains the customer's Installment amount he should pay in monthly and other columns contain the actual amount he paid on the month. And I want to categorize the amount paid by the customer as below in power bi
Installment = paid amount(each month)

Installment > paid amount (each month)

Installment < paid amount(each month)

Installment = 0

What is the method I can use

 

1 ACCEPTED SOLUTION
camargos88
Super User III
Super User III

@sekinod ,

 

Check the attached file again.

 

I've created a measure to return a value and format the background based on this return. Check also the background conditional formatting.

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

6 REPLIES 6
sekinod
Helper II
Helper II

@camargos88 
Thank you very much for your help, I highly appreciate your effort.

camargos88
Super User III
Super User III

@sekinod ,

 

Check the attached file again.

 

I've created a measure to return a value and format the background based on this return. Check also the background conditional formatting.

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

camargos88
Super User III
Super User III

@sekinod ,

 

Check the attached file.

You can also apply a new column. 

 

If this is not what you want, please tell me how you need to show it.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 

thank for your help. I would like to see the table more like this

3.JPG

and instead of 0 and 1 , the month columns should contain the amount he has paid relevant to that month and field format (background color or preferably using icons) the cell as per the previously mentioned categories.

camargos88
Super User III
Super User III

@sekinod ,

Is Installment > paid amount (sum of all months or each month) ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 

each month

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors