Turn off X axis Clustered column value for only one hierarchy

[Karthik12]

Hello Folks,

Have a Great time ahead ! 

I have one issue with my clustered column bar graph. You can see, I draft a bar graph with many axis catagory (refer attached image).

I am trying to turn off - one of the catagory value in X axis but couldn't. Can anybody help me out with solution?

Thanks a lot in advance !

[Karthik12]

Hello Denis,

Thanks for your time. I wouldn't like to remove the last axis. I want to hide the respective number alone in the bar graph.

Since this clustered bar graph made from 3 different tables, labels of all 3 tables shown at the bottom of the graph.

so, I want to hide the label only from last one, don't want to remove complete data of the particular one.

If I do it via Visual-> X axis, all 3 values used to disappear. So, I would like to turn of only that particular value in the bottom of the bar graph.

[Karthik12]

Hello Denis,

Thanks for your time. I wouldn't like to remove the last axis. I want to hide the respective number alone in the bar graph.

Since this clustered bar graph made from 3 different tables, labels of all 3 tables shown at the bottom of the graph.

so, I want to hide the label only from last one, don't want to remove complete data of the particular one.

If I do it via Visual-> X axis, all 3 values used to disappear. So, I would like to turn of only that particular value in the bottom of the bar graph.

[Karthik12]

Hi, you meant that, can we turn off the legend in the x axis only for the last source? Actaully you see there are 06:00:00, 07:00:00, 6 these 3 labels comes from different source and it add in the grapg value. Now, I would not like to affect the graph. Just visual turn off the 06:00:00 only in the bottom of the bar graph. Is it possible?

[selimovd]

Hey @Karthik12 ,

I'm not sure if I fully understood what you want to archive.

If you want to "turn off" the last x-axis you can just remove them with the x symbol:

As an alterative you could drill up one level.

If you want the last 2 number to be hiffen, you can do that by using a custom format string for that column:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings#how-to-use-cu...

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic