Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Multiple X-axis values

Hi everyone,   I have a number of bar graphs with multiple x-axis values (date, week, month, customer, etc). The purpose for this was to be able to drill up/down and see the different values. Just ...
Need Help
Nhallquist's avatar
Nhallquist
Helper V
10 years ago

Thanks. I think I see what you are trying to do here.  Can you remove the field from the Legend?  Also, a complete picture of the graph would be great.  I would like to see if the Drill Down arrows are activated or not.  I can't see them, but I have to think they are not working and it might be becuase you have a value in the legend that is not a dimension.  However, this is just a thought.

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Nhallquist - I have done a check on a few other files and the same thing is happening. However I checked the same reports in Powerbi.com and this issue does not occur. It appears to be a bug on the desktop version that doesnt carry through to the web version. 

 

I have sent a frown to the PBI team.

 

Thanks,

 

Giles

  • javedbh's avatar
    javedbh
    Helper II
    10 years ago

    If you are using the button "Drill all to the next level" then you should read April Update Feature Summary

    They call it "In-line hierarchy labels for drill levels (Preview)".

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    10 years ago

    Hi GilesWalker

     

    In Power BI Desktop, the Drill action is based on all data, which means when you drill down to child level, it will return child member of all parent level members. For example, if you drill from Year to Quarter, it will show quarters in all years instead of 4 quarters in one year. So in your scenario, when you drill to Date level, all dates appear on X-axis. For your requirement, you need to create a silcers on different level to filter those members you want.

     

     

    Regards,