Stack coloumchart grouping

[Anonymous]

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?

[Anonymous · Accepted solution]

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]

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

[Anonymous]

@amitchandak Can you please help on figuring out this?

[amitchandak]

@Anonymous , Try like

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

[Anonymous]

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?