Help with combining specific values within a column

Hi MiloT ,

You could create an additional custom column where you specify your values that you would like to summarize and the ones that you just wanna leave as they are. For instance like this:

Sales Activity Custom = 
SWITCH (
    TRUE,
    Table[StageName] = "discovery", "DPB",
    Table[StageName] = "pitch/demo", "DPB",
    Table[StageName] = "bid/proposal", "DPB",
    Table[StageName]
)

Then you can just use that new attribute.

Does this help? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Hi MiloT  ,

For your other query to sort the legend of your stacked bar chart, you can use the sort by column function in column tools. Essentially, you can specify an order for your values there.

Here a blog post where it is explained pretty well 🙂

Custom Sorting in Power BI | Tessellation (tessellationtech.io)

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/