Forum Discussion

pxg08680's avatar
pxg08680
Resolver III
8 years ago
Solved

Grouping Country Name

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.

  • Hi pxg08680,

     

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

     

    Best regards,
    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi pxg08680,

     

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

     

    Best regards,
    Yuliana Gu

    • pxg08680's avatar
      pxg08680
      Resolver III

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    Hi, can you create a custom column on the table and use a switch statement to determine the grouping