Forum Discussion

jpaplanus's avatar
jpaplanus
New Member
8 years ago
Solved

(Blank) in clustered column chart

I have three tables providing resource data, all providing the same information from three different time periods (Sept, Jan, Apr). Each table contains a field that has a unique ID. I am using this f...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi jpaplanus,

     

    You can add a Month No column in each table. 

    Sep Table: New Column="Sep"

    Jan Table: New Column="Jan"

    Apr Table: New Column="Apr"

     

    However, if each table contains a date column, the new calculated column could be New Column=Month(TableName[Date])

     

    Then, Union above three tables. When you create the clustered column chart, place [New Column] into Legend section, add [City] to X-axis, and add [Value] to "Values".

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi jpaplanus,

 

You can add a Month No column in each table. 

Sep Table: New Column="Sep"

Jan Table: New Column="Jan"

Apr Table: New Column="Apr"

 

However, if each table contains a date column, the new calculated column could be New Column=Month(TableName[Date])

 

Then, Union above three tables. When you create the clustered column chart, place [New Column] into Legend section, add [City] to X-axis, and add [Value] to "Values".

 

Best regards,

Yuliana Gu

jpaplanus's avatar
jpaplanus
New Member
8 years ago

v-yulgu-msft, thank you for the additional idea of adding in the month column. My data did not have a date field as it was not needed, but adding in Sept 2017, Jan 2018 and Apr 2018 did the trick. After creating the UNION your recommendation on which data fields to apply to which section lined it up perfectly for me!