Forum Discussion
Dynamic limits
I have a group of segments that have boundaries and I put them on a chart, I had no problem relating them. I have the difficulty with the limit that must be applied to the total, since I have no way to associate it with any segment since it is the limit of the sum of all segments. How could I do if I want to have them all in a single graph?, that when I select a segment I am shown its limit, but when I still the filters I have the limit of the total.
| Segment | Limit 1 | Limit 2 |
| Segment 1 | 12 | 34 |
| Segment 2 | 56 | 78 |
| Segment 3 | 90 | 01 |
| Segment 4 | 23 | 45 |
| Segment 5 | 56 | 67 |
| Total | 89 | 01 |
2 Replies
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.
TheoI 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
