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!!
