Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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!!
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...
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 48 | |
| 38 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 93 | |
| 79 | |
| 37 | |
| 27 | |
| 25 |