Forum Discussion
How to add multiple fields in Chart Axis ?
- 11 years ago
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 )
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.
- konstantinos11 years agoMemorable Member
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 )
- WillT10 years agoCommunity AdminWe 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
- bdenison9910 years agoNew Member
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.