Forum Discussion
Helper IIHow to un-remove items from a chart (i.e. Show All)
Hi mossshvlw ,
If an item is deleted directly with remove, you can use Ctrl + Z to restore it
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper III'm sorry, but to me, that does not seem normal or user-friendly in the least. I would think removing a category (not realizing you can't get it back) is probably an expected part of many users' workflow. And no, this is not a calculated measure or anything like that, the data is literally is in my table, it just will not render in the chart since I removed it at one point.
I'd also have to ask, what is the point then of right-clicking on the table and having the view hidden/unhide all options?
I don't mean to sound bitter, but it's things like this that will make me choose literally any software over Power Bi.
Community Championoh that is very interesting, i didn't realise you meant you literally couldn't add it back in. That seems very odd. You dont sound bitter, its just a case of understanding. User friendly is the name of the game and of course power bi is purposed for that but its definitely a work in progress.
I do not think though that i have had the same experience as you can you literally tell me the steps of what happened so i can understand better.
where did you remove the category from? did you look in the relationship layout view. when you hide a column you can only see it in that view.
- mossshvlw
Thanks. I'm not sure how else I can describe it. Other than, I had a bar chart that displayed data from one field. i.e. "Male", "Female", and "Other". I hit "remove" on "Other" (see photo example above), and that category dissapears. "Other" is still in the field itself. There's just no way to add it back into the chart without re-building from scratch. I've even tried removing the fields from the visual and re-adding them : nope, it's gone forever.
You can see that with a more complicated example, not having this ability is extremely problematic. Which is why to me, Power Bi still sucks.
- vanessafvg
its odd because i cant seem to remove just one value of a category with the remove function. did you do an exclude maybe? if you did an exclude you would find the filter to unremove it in the filter section, probably an obvious question but just checking that you checked there? I excluded a category in this pie chart , if remove the exclude from the filters it will bring it back.
- mossshvlw
Thanks. I did a "remove" after right clicking on the chart - see my photo in my post.
- vanessafvg
the only thing i can think of is something very strange happened as there is no way that i can see to remove one individual category with the remove function from a bar chart without removing the whole bar chart. If you are able to share your pbix with the problematic visual that would be the best thing to do.