cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jschlereth
Advocate IV
Advocate IV

Category Label Displaying on Y Axis in Drill Down

I have a clustered bar chart where the data bars go from left-to-right and I have a 2 level hierarchy plotted on the y axis. Everything shows as it should, but when I drill down into one category, the overall category name always appears first and "hides" the detail name. I'd either have to make the visualization really large to show the detail name or have the user "hover-over" the bar itself to see the name, but are tedious at best.

 

Is there a simple configuration setting that I'm missing that will hide the category name when I drill down? 

 

I've even switched to the more "normal" bar chart where the bars are running from top-to-bottom and I've turned off "Concatenate labels" on the x-axis, but this doesn't change the visualization at all. I'm wondering if the "Concatenate labels" option is busted. It would be nice too to have this feature on the y-axis for the left-to-right bars...

 

Any help would be appreciated. Thanks.

 

 

1 ACCEPTED SOLUTION

Hi @jschlereth,

 

After test again, I found the custom hierarchy column will auto add the parental level label before the current column label. It seems also not support to your requirement. I think you can vote below idea which has the same requirement:

Better data label customization

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

11 REPLIES 11
TimoRiikonen
Helper III
Helper III

The request doesn't match with the idea:

The request is that you would fix the text content. Now the previous selections are shown in the text, which is very bad. Basically we can't see the text at all as previous selections are so long that we will never see the texts associated with the visible bars. So just remove the previous selections from the text.

NOTE: on 5% of cases, this already works correctly. So this happens in our reports only in 95% of cases. So maybe your dev team happened to get those 5% results where which works in a sensible manner.

Idea linked is about cases where you have too many rows and has nothing to do with this problem.

Please look at the picture attached:

Here this works correctly:

image.pngimage.png

And here it works wrong and repeats the text "Toiminnan kulut" after drilling in:

image.pngimage.png

vengel
Frequent Visitor

Is there any update concerning this topic?

 

In my current dashboard I run into the exact same issues. What makes it even stranger is that for one clustered column chart it works as it should (only showing the category label of the current hierarchy level), but for another clustered column chart (same report, other page) it shows the category labels of all the levels, starting with the first one, which makes the third level category label impossible to read...

Anonymous
Not applicable

Hi jschlereth,

 

I thought I'd add my thoughts to this and this is my first post and thought I'd give something back to this fabulous community which has really helped me out of some tricky situations.

 

My solution was found more by clicking lots of things as opposed to a refined theory behind the workings of Power BI.

 

When you have a clustered bar chart (ie bars going horizontally), switch it temporarily to a clustered column chart and then go to format the X-axis where you'll now find an option to concatenate labels. Turn this off and change the chart back to a clustered bar chart. 

 

Hope that helps others too.

I know this has been deemed solved already, but I am having this issue as well. I tried turning off contactate in the clustered colum and then switching back, and it doesn't work. 😞

Hi,

the same is with X axis. Funny part is that I've managed to create chart which is showing only data labels for current drill through level and have it saved. Now tried to do the same and level one is concatenated with level 2 which is annoying. I have re opened old file and copied old chart to new sheet, set up all setting to match and have 2 charts, one shows concatenated labels (new) and one which shows only current level labels (old).

 

Any ide what is going on?

 

edit: nevermind, don't know why but all of my charts now show only current drill down labels

 

dan

elnaggar
Frequent Visitor

Hi @jschlereth,

 

 I found something which may solve your problem as long as its or 2 levels, if you press on the "go to the next level in the hierarchy" it will only show you the dimensions of the second level and not combined with the first level. 

 

Thank You

This is not a solution, as if you do go to next level, you would be showing sublevel data from all categories, while in drill down, you go to the sublevel only on that selected category.

v-shex-msft
Community Support
Community Support

Hi @jschlereth,

 

>>Is there a simple configuration setting that I'm missing that will hide the category name when I drill down? 

Power bi not contains the setting to show the up-level column, when you drill down the hierarchy column, it will auto switch the label to current hierarchy level.

 

In my opinion, you can create custom hierarchy column with specific format(e.g. Create three calculate column, then use these columns to create a hierarchy column with: year,month year,day month year)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@v-shex-msft,

Thanks for your response. I must be doing something wrong then, because my visualization has done just that. I can't seem to find what I did wrong. 

 

Here's my example: 

  • On the "top" level of the hierarchy I have Category Titles (multiple jobs fit into one category)
  • On the "bottom" level of the hierarchy I have specific Job Titles

 

In this screenshot, you can see the specific hierarchy that I have set up in both tabular format and in the "Drill down" format of the bar chart, showing the "bottom" level with the "top" level concatenated on to the bottom level title.

Hierarchy_OnYAxis.png

 

Any clue as to how I did this and how I can fix it?

 

Thanks,

Jonathan

Hi @jschlereth,

 

After test again, I found the custom hierarchy column will auto add the parental level label before the current column label. It seems also not support to your requirement. I think you can vote below idea which has the same requirement:

Better data label customization

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Hi @v-shex-msft,

Thanks for the confirmation and the link for the idea.

 

Jonathan 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors