Showing results for 
Search instead for 
Did you mean: 
Advocate IV
Advocate IV

Hierarchy Slicer - Unexpected Error


Today I opened a .PBIX file where I use the Hierarchy Slicer. The moment after the report was opened in PowerBI Desktop I got this message:


Unexpected Error
An error occured while rendering the report.

"Send a Frown"



After doing some investigation I concluded that the Hierarchy Slicer was the source of this error. If I delete the custom visual I do not get the error. Imediately after I download it again from Office Store (through PowerBI Desktop) and put my dimension column in it I get the error.


This has never been an issue before. Anybody else experience this?


For all the issues fixes are being release in the next couple of days/week. I am still dependant on a store approval before new version will start rolling out to everyone.

But I got reports that clearing the cache of either Chrome or Desktop will solve the issue. For Power BI Desktop you can remove the content of the C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop directory.


Thanks, JP


Have you heard anything on when this would be approved? 


The newest update is already out v1.1.5.0


Thanks - when I looked at the detail it said 1..1.5, but then it also said it wasn't published yet.  I did download and it is working well.



I am just, as we speaking, updating the store description. And yes, the v1.1.5 version is general available.


But due to the approval cycle related to the Office store and when the visuals are available: it can take two weeks before a new version is available to users after store approval. So that is the reason that I submit the original description with the notice of 'not released' and after general available I update the description, but I am running behind on this one.




Thanks @jppp!


There's another issue I am experiencing with the Hierarchy Slicer. The slicer errors out if the 'Search' functionality is turned on. It works fine when we search something in the search bar, but errors out to 'Unexpected Error' when we try to make any selection without anything in the search bar. Do you have any suggestions?

Frequent Visitor

I added a hierarchy slicer to my visual and it is not working.  It only displays the actual dates and does not display select year, month or quarter.  I have used it successfully in other reports and I don't think I did any special configuration.  Any ideas?





Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors