Forum Discussion
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
- lbendlinSuper 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-Forum/ba-p/963216
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/1447523