Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Syndicate_Admin
Administrator
Administrator

Problem with line chart filter when using Future Receivable Amount ranking

Hello everyone!

I'm facing a problem in my Power BI project and I was wondering if you could help me find a solution. Here's the situation:

I'm working with two tables, one for "Settlements" which contains general details and summary of the status of credits, and another for "LiqInstallments" which has the detail of each installment corresponding to those credits, related by the Settlement ID.

I've created a chart that shows detailed information about credits, amounts, installments, and Future Receivables, which is the sum of outstanding installments. This chart is filtered by a "Future Receivable Amount" ranking, which is controlled by a segmenter with a table of parameters ranging from 1 to 50. Therefore, when you select a value in the segmenter (1, 5, or 10, for example), the chart only shows the credits that have the largest future receivables.

I have used the following DAX measures to achieve this:

LiqFutureRank =
RANK( DENSE,
ALLSELECTED(Settlements),
ORDERBY(CALCULATE(SUM(Settlements[Future.Amount]))),DESC),
LAST)

ParameterValue =
IF( SELECTEDVALUE('ZFf Rank Parameter'[ZFf Rank Parameter ], 10) >= [LiqFutureRank], "Yes", "No")
ParameterValue has been added to the credit card visual filter.

So far so good. The problem arises when I try to filter a line chart with axes on the due dates (months) of the installments and the sum of the amounts. Despite having applied the same ranking filter, the graph does not fit properly and displays unwanted information.

The desired display is Segmenter = 1, with the largest credit filtered in the detail box and only the flow of receivables from that credit filtered in settlements.

I would greatly appreciate any suggestions or help to fix this problem. Has anyone faced a similar situation or has any idea how to approach this?

Thank you in advance for your cooperation!

Best regards!!




1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.