Forum Discussion

Ganapathi's avatar
Ganapathi
Frequent Visitor
11 years ago
Solved

How to add multiple fields in Chart Axis ?

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 V...
Need Help
  • konstantinos's avatar
    konstantinos
    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 )

WillT's avatar
WillT
Community Admin
10 years ago
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's avatar
bdenison99
New Member
10 years ago

 

 

 

 

 

 

 

 

 

 

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.