Stacked column char (4 regions + 1 country)

[tsynenkyy]

Hi Guys,

I have the following column char:

As you can see there is the net saving splited by regions, what I need is to have 4 regions + 1 country, for example:
LA, AA, EU, NA, Germany.

I extract everything from one table. The problem is that I have one column for Regions and another one for Countrys.

How can I insert one country to that graph?

Thanks

[v-stephen-msft · Accepted solution]

Hi @tsynenkyy ,

As a workaround, you could create a seperate table with one column which has regions and countries as follows.

Then create a measure with SWITCH() function. For example,

Measure =
SWITCH (
    MAX ( 'TableName'[Regions/Countrys] ),
    "LA", [Expression1],
    "AA", [Expression2],
    "EU", [Expression3],
    "NA", [Expression4],
    "Germany", [Expression5]
)

Then put the measure into Values, put the Regions/Countrys column into X-axis.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tsynenkyy]

Hi, thanks for your answer.

What is the "Expression1, Expression2..."??

is the measure net saving?

[v-stephen-msft]

Hi @tsynenkyy ,

You can replace the “Expression” with your own measure or specific formula.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.