Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Selectively remove some labels on the X axis of a bar chart

Forum question.JPG



is there a way to produce this, just a regular bar chart, but only a selected label can be seen.  Thank you.

Community Support
Community Support

Hi @swragg ,


You could try slicer or filter to meet your requirements.

Or do you mean to show the only corresponding result when you click the label in the visual?


Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Resolver II
Resolver II

Have you thought about slicers, Top N, or categorizing your locations?


I don't know what type of data you're reviewing, but creating a dynamic chart like this to quickly switch between different categories of intrest may be best if your dataset icludes many locations. Otherwise, I'd allow a slicer to determine the "selected label(s)".

The slicer would leave only with one location, when I want to comapre the location to the anonymized other locations.


Thank you for the idea.

Utilizing a slicer doesn't limit you to a single value.


With Slicers you can select multiple values. You also could categorize your data - Then slice by top performer, locations with the greatest change in revenue, or what ever you could think of.


It honestly sounds like Slicers, and modeling your data would get you a solution to your issue.


Share some examples, I'd be happy to assist.



This I am unaware of. I also am not certain if this is achievable with DAX. I woluld be interested in a solution.

However, if you're trying to bring attention to a particular value you can play with the conditional formatting settings.

I apologize.

No need to apologize. This is a very specific request for which there may be no solution at this time.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors