Forum Discussion
Hide a specific column in bar chart without affecting the values
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
8 Replies
- Ashish_Mathur
Super User
- Ashish_Mathur
You are welcome.
JolienRHelper II
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.
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
vibhoryadav23I 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.