Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Stack coloumchart grouping

I have to create a stack coloumn chart with the below table which is created using summarize DAX function from another table

osp = SUMMARIZE(Combine,Combine[Month],(Combine[osp]),"connections",count(Combine[connection]))

osp is the name of the app and connections are the number of apps connected per month, In the stack chart I want to show the apps per month and apps with less than 100 connections into a separate group. How can this be done?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You need to create a calculated column with the IF function, for example.

    Column = IF('Table'[connections]>100,'Table'[osp],"others")

    Attached PBIX file for reference.

     

    Best Regards,

    Gao
    Community Support Team 

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Try like

     

    osp = filter( SUMMARIZE(Combine,Combine[Month],(Combine[osp]),"connections",count(Combine[connection])), [connections] < 100)

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for that, but what I'm looking for is different


      In the above graph, all the  osp with less than 100 connections per month  should show as "others" in the graph, How can this be done?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    You need to create a calculated column with the IF function, for example.

    Column = IF('Table'[connections]>100,'Table'[osp],"others")

    Attached PBIX file for reference.

     

    Best Regards,

    Gao
    Community Support Team 

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks it Worked, I got visuals in the stack chart

      I tried to sort the legend with the highest connections at the bottom and then go in descending order. I have used the sort using legend but it's not sorting the visual. How can I sort the legend based on the connections