Grouping Country Name

[pxg08680]

Hi everyone,

I have few columns in my data set.

RegionName, CountryName, Variance.

I need a chart which looks like below

The bars indicate variance for each country. Few bars are grouped together which indicate that these countries are from a single region. Next group of bars indicate another region. 

I am able to create a chart this way. This shows variance for different regions and when I drill down a particular region I can look for countries. But I need my chart as mentioned in 1st image.

Any kind of help is appreciated.

Thank You.

[v-yulgu-msft · Accepted solution]

Hi @pxg08680,

Maybe you can add [CountryName] into legend section of the clustered column chart.

Best regards,
Yuliana Gu

[pxg08680]

Thank You for the solution.It's working perfectly.

[Anonymous]

Hi, can you create a custom column on the table and use a switch statement to determine the grouping