Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
@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
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |