Hide a specific column in bar chart without affecting the values

[LinlookZDJ]

Dear Power BI Experts, 

Is there any ways I can 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 want to hide a specific bar from showing only. 

Below is how my bar chart look like and i just like to hide the first 5 bars. The value for other bars should remain unchanged.

Attached sample file for your reference.

https://drive.google.com/file/d/1rUzl2QJjkeRK0lPLoVXqRIyQijI6cEyX/view?usp=sharing

Thanks for your kind assistance in advance!

Best regards

 

[vibhoryadav23]

I am looking for this solution. Can someone share the file or the way to solve this?

[Ashish_Mathur]

I do n ot havehat file.  Share some data to work with and show the expected result.

[marenecaCZ]

Hello Power BI experts,

could I ask you one similar question to this topic? 

Let's say that I would like to hide firts 5 bars in the bar chart without affecting the other values. But I would like to do it by slicer filter. The slicer filter shoud have two options:

1) "hide first 5 bars"

2) "display all values"

The first option will hide the first bars without affecting the data in the bar chart.

Could you please help me how can I do it?

Thank you very much

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[JolienR]

@Ashish_Mathur can you maybe re-upload the file again? I'm looking for this solution as wel. 

[Ashish_Mathur]

Unfortunately, I do not have that file.

[LinlookZDJ]

Hi Ashish Mathur,

Appreciate for your time and solution, it works!

Best regards

[Ashish_Mathur]

You are welcome.