chart like a pivot table

So, yes and no. I think you can achieve what you want with a Matrix visualization and a slicer. So, the matrix visualization would look like your pivot table with the groupings, etc. but it does not have collapse/uncollapse features. However, if you also put a slicer on your report, then you can use the slicer to zero in on a particular "something" in your matrix.

Some visualization types, like column charts and bar charts, support "drill down", which also sort of does what you are asking about, but the Matrix visualization does not support drill down.