Forum Discussion
Dynamic limits
Syndicate_Admin if you could provide an example of the output you want, it would be very beneficial. However, if I understand correctly, you may be able to achieve what you want by using Power Query and selecting both columns (Limit 1 and Limit 2) to unpivot. These will then give you an Attribute column (i.e. Limit 1 and Limit 2) and a Values column (i.e. the values in the respective limit columns).
If it's not what you want, please let me know and I or the Community can better assist 🙂
Hope this helps.
Theo
I have this graph associated with your limit for your segment, this chart is correct its upper limit is 5.80 and the bottom 1.59.
When removing the filter and leaving all segments, a limit is calculated but in reality the limit for all segments are others (upper 3.70, lower 1.32). How can I do so that in the total I can link the actual limits to the total?
| Wallet | Defeated | Delinquency |
| Commercial | 1.72 | 4.42 |
| Mortgages | 1.59 | 5.80 |
| Personal | 0.35 | 1.00 |
| Cards | 2.56 | 6.50 |
| Form | 2.30 | 10.00 |
| Factoring | 3.00 | 6.00 |
| Total | 1.32 | 3.70 |