Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 w...
  • parry2k's avatar
    5 years ago

    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.

  • v-cazheng-msft's avatar
    5 years ago

    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