Forum Discussion

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

If I understand your requirement correctly that you want to create the clustered column chart in power bi based on the data table like the second image?

If it is, could you share your data sample with table format so that we could copy and test on it?

Best  Regards,

Cherry

 

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident Rockstar
      7 years ago

      Hi Anonymous ,

      For your table format, I'm afraid that we cannot create that chart in power bi.

      As a workaround, you could duplicate the original table and then Unpivot the date columns for the table 2 in query editor so that you could get the date column as the x axis for the clustered column chart.

      In addition, I have a little confused about the Sales 14 and Sales 13, it seems that there is no column named Sales 14 and Sales 13 in your table format.

      Best  Regards,

      Cherry

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks for your reply! But I don't want to change the format.