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 View in Excel. Could you please assist me on this.

 

Snip.JPG

 

Regards,

Ganapathi

  • 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 )

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
      konstantinos
      Memorable 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 )

      • WillT's avatar
        WillT
        Community Admin
        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