Forum Discussion
Grouping
Hello - I need to group three of the segments in this graphic as one, and then the others remain.
So I need the sum of JLGdwell + JLGinc + JLGpublic = JLGcommunity.
On the visual it would read... JLGcommunity, JLGk12, JLGsport, JLGedu, JLGmed. 5 columns instead of 7.
Any help is appreciated!
Anonymous the faster way to add a new column in your table and then use that on the x-axis
New Group Column = IF ( Table[Current Column] IN { "JLGdwell", "JLGinc", "JLGpublic", "JLGcommunity", Table[Current column] )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi, Anonymous
Is your problem solved? You can create a new column with parry2k’s solution and then use it as the X axis to create your visual.
Best Regards,
Caiyun Zheng
4 Replies
Anonymous the faster way to add a new column in your table and then use that on the x-axis
New Group Column = IF ( Table[Current Column] IN { "JLGdwell", "JLGinc", "JLGpublic", "JLGcommunity", Table[Current column] )Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thank you @parry2k ! this was great.
Hi, Anonymous
Is your problem solved? You can create a new column with parry2k’s solution and then use it as the X axis to create your visual.
Best Regards,
Caiyun Zheng