Showing results for 
Search instead for 
Did you mean: 
Nejovic Regular Visitor
Regular Visitor

How to Hide a Specific Bar in Bar Chart Without Affecting the Vales

Hi All, 

I wandered how to hide a specific bar from a bar chart without affecting the vaules? The bars are showed as a parcentages, and whenever I choose exclude, or filter values, the total amount always sums up to 100%, and the values for other bars change, which make my calculation innacurate. 

I just need to hide it from the visual. 

Moderator v-yuezhe-msft

Re: How to Hide a Specific Bar in Bar Chart Without Affecting the Vales

@Nejovic ,

Could you please share some sample data to use for test? According to your description, my understanding is that you want the parcentage number not changed when you use the exclude.

In this scenario, we can create a measure for each item to calculate their percentage, and drag these measures to the visual. Please refer to the following example:

1. Create measure for all items to calculate their percentage, please refer to the following query:

Donsales = DIVIDE(calculate(***,'HR Employees'[firstname] = "Don"),***)

2. Change the data format to %, Drag these measures to the visual.



Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 263 members 2,873 guests
Please welcome our newest community members: