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",coun...
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!

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?