Cluster Column Chart with several X axis

[Anonymous]

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 which works nicley, formatted to show Year, Qtr the the Month.

But in PowerBI, I can only apply 1 'X' Axis so I grouped the values "=Year & Month & Qtr" to get what you see below but visually this is not ideal even though it works.

Any ideas how I can re-create the same chart I produced in MS Excel, using 3 Axis, in Power BI? 

I am using the default Cluster Column Chart.

Many thanks

Chris C

[themistoklis · Accepted solution]

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]

Hi themistoklis

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

[Anonymous]

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