Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unable to create Clusterd Column Chart

Hi,

I need parameters like Engine, Tyres, Lamps on X axis and Stages on Y (Value). When I do Stage1,2 on Value, it takes the "Count of stages" plus the X axis is also not showing up as desired.

My data format cannot change and will remain as below

 

 

 I am only able to get the desired result if i transpose the data which i do not have option to.

 

Appreciate your help.

Need Help

12 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous you already found the solution what you need to do. Any reason why you can transpose the data in powerbi. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      I cannot transpose as the rows Stages1,2,3... keep incrementing and if I need to automate it i cant take the stages in columns. Hence measurements have to stay in columns- fixed and stages in rows- incremental
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        The transpose can happen dynamically in the Query Editor and from the transposed dataset, your chart can get created.