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

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,