How to add multiple fields in Chart Axis ?

[Ganapathi]

Hi all,

I am trying to add second field in chart axis but Power BI desktop is not letting me to do. Please find the below screenshot for your reference.

But I can do the same thing in Power View in Excel. Could you please assist me on this.

Regards,

Ganapathi

[Greg_Deckler]

I don't believe that is a feature of Power BI Desktop yet. Can I ask why you need 2 X-axis? Probably need 2 charts with same value but different axis, one for Month and one for Week. If you have a date field, like 1/1/2015, and use that as your axis, it generally does a nice job of summarizing the display in the axis.

[konstantinos · Accepted solution]

Drill down feature is not supported yet in PBI desktop..Only in excel powerview and use the PowerBI service old report canvas ( rendering engine )..The drill down feature promised to return by the Team better discoverable in the coming updates...

For now @Greg_Deckler way is the best workaround..or excel powerview ( which you cannot use any of the new visuals - as when editing in Service it will promt you to save it in the new report canvas )

[WillT]

We have recently added the ability to drill down in visuals, so you should be able to drop multiple fields into that area! Hope that helps Will

[bdenison99]

Drill down isn't helpful in my use case.  I need multiple values on the X-axis to give me an 'at-a-glance' view comparing two sets of data.

In my case I specifically need to graph the throughput of a storage solution in MB/second on the y-axis, and the following items in descending order on the X axis:

Queue Depth

Block Size

Random / Sequential

Read / Write mix

As you can see, this produces a set of 'mountains' which correspond to Random Read at various block sizes and queue depths, Sequential Read at various block sizes and queue depths, Random Write at various block sizes and queue depths, and Sequential Write at various block sizes and queue depths.  Each storage solution gives me a single line which tells me how each solution does under the workload represented by those mountains.  Drill down would completely remove the at-a-glance nature of my reporting.

[KHorseman]

Edit: nevermind, the screen I was on is too small to see what you were referring to in your screenshot.

[Sean]

@bdenison99 Unfortutunately this is not currently possible

Look at my answer here

http://community.powerbi.com/t5/Desktop/Nested-values-in-xaxis/m-p/30076/highlight/true#M10219

And then Vote here...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11524623-nested-x-axis-labels