Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cluster Column Chart with several X axis

Hi   I trying to re-create a Power Pivot Chart I created in MS Excel which allowed me to apply 3 'X' Axis; Month, Qtr & Year, these are are taken from a seperate data table.  See snippet below whic...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    Hello Anonymous ,

     

    On the chart click the drill down icon (top of the chart)as many times as needed. See image below.

    If you want to see year and quarter click on the icon once. If you want to add month as well, click the icon 2 times in total.

     

     

    The go to format options and turn off 'Concatenated Labels'

themistoklis's avatar
themistoklis
Community Champion
5 years ago

Hello Anonymous ,

 

On the chart click the drill down icon (top of the chart)as many times as needed. See image below.

If you want to see year and quarter click on the icon once. If you want to add month as well, click the icon 2 times in total.

 

 

The go to format options and turn off 'Concatenated Labels'

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi themistoklis

     

    Thats is just what I am needing, but I dont see the drill down icon you mention.  I am using PowerBi desktop, even looked at the Workspace and App istself.

     

    Chris

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi themistoklis

     

    Just did some diogging arounds and I now understand, perfect it works great thanks for the info.