Forum Discussion

pfInigo's avatar
pfInigo
Frequent Visitor
3 years ago

Clustered Column/Bar Chart with grouping and ordering

Hi,

I want to display data in a column/bar chart as I was previously able in Excel Pivot Chart (see below).

The chart has grouped the Years by Syndicate Number and order them by the Amount. 

However, I can't seem to find the setting in PowerBI to do this, and the drilldown does not do what I want it to do.

 

I feel I am potenitally missing something obvious.

Thanks in advance,

Paul

Need Help

3 Replies

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    3 years ago

    pfInigo ,

    drill down is the option as you see in the below image,

    Thanks,

    Arul

     

  • pfInigo's avatar
    pfInigo
    Frequent Visitor
    3 years ago

    Sorry I should have been more clear - there are two values in my chart (i.e two columns)

    There is a parent (A) and children (B) and two values Premium and Losses - as per below. 

    Is there a way to do what I am trying?

     

     

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      3 years ago

      pfInigo ,

      Would be helpful if you provide the sample data?

      Thanks,

      Arul