Unable to select highest hierarchy date in bar chart visual

[Juliecal73]

Hi,

Has anyone come across the situation where you have a normal bar chart with date heirarchy along X and values up Y with level expand enabled to display Month, Qtr and Year. If I am on any of the lower levels like Qtr or Month, I can select the Year value and it responds accordingly which also allows for a drill-through that I have set up with the dates and value (I have buttons enabled/disabled for drill-through to be effective on the axis values).

However, if I collapse the hierarchy to the Year only level, I am not able to select the year and not able to drill-through with my buttons either since the year does not behave as expected when slected.

Lower levels I can select Year (bold 2020 while other bars are faded for 2021).

Year level I cannot select the year (not bold and bars not faded for 2021). Interestingly enough I just saw that if i select the year in the lower level, then collapse, then the year remains filtered, but I still cannot drill-through

Thoughts?

[v-shex-msft · Accepted solution]

HI @Juliecal73,

Sure, I try to create some dummy data and test with a similar chart and graph.

>>However, if I collapse the hierarchy to the Year only level, I am not able to select the year and not able to drill-through with my buttons either since the year does not behave as expected when slected.

Yes, I think this is works as expected, drill feature not available when you use single fields of hierarchy.

>>Year level I cannot select the year (not bold and bars not faded for 2021).

Based on my test, you can only pick up legends types when you work on the top level. (I think the click event is used to pick the detailed items instead of direct get multiple items. If you remove legend fields, the click function will select data bars of year level)

BTW, you can 'hold on' the 'control' key to use the mouse to select a range of data bars.

Regards,

Xiaoxin Sheng

[Juliecal73]

Hi @v-shex-msft ,

Thanks for checking this out and sharing your experience with it too. At least now I know it's not a defect with mine and just expected.

Thanks also for the reminder of the ctrl-click on the bars, I had not considered that, only did it with values 🙂

[v-shex-msft]

Hi @Juliecal73,

What type of drill features are you test? Have you works with 'drill to next level' or 'switch between hierarchy levels'? Did these hierarchy fields really exist in your charts or your just test with single hierarchy parts?
BTW, it will help if you share a sample pbix file to test.

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng

[Juliecal73]

Hi @v-shex-msft,

I assume when you say 'switch between hierarchy levels' you mean the Expand feature? I am using Expand.

Also unsure of your second question, but the fields actually exist in my chart.

I'm unable to share this .pbix as it has internal data.