Hierarchy Slicer Not working

Question

Hi Team,&nbsp;I am trying to use Hierarchy Slicer on my data in power bi desktop file however i am facing an issue "An error occured while rendering the report".&nbsp;I already updated the latest version of power bi desktop, and still i am facing this issue from last couple of weeks.Please see the below screenshot of the error.&nbsp;&nbsp;&nbsp;If anyone can help me out, how to solve this issue?&nbsp;Thanks in Advance,Ashish&nbsp;&nbsp;&nbsp;

tahreem24 · Answer

Hi&nbsp;Ashish_kumar12&nbsp;,&nbsp;I am not facing this issue. (Screen shot is attched)Try to close your file then open it again.&nbsp;&nbsp;Please give KUDOS and accept it as a solution if it helps!&nbsp;

ashish_kumar12 · Answer

Hi&nbsp;Tahreem24&nbsp;&nbsp;I already closed my file so many times and applied that slicer however still facing that issue.&nbsp;Do you have any other alternative ?&nbsp;Thanks,Ashish&nbsp;

icey · Answer

Hi&nbsp;Ashish_kumar12&nbsp;,Please follow steps below&nbsp;to see if it works.1) Close all instances of Power BI Desktop2) Open file explorer and navigate to the folder &lt;system drive&gt;:\Users\&lt;user&gt;\AppData\Local\Microsoft\Power BI Desktop\CEF\cachereplace &lt;system drive&gt; with your operating system hard disk partitionreplace &lt;user&gt; with your user profile name, typically the alias you login to Windows with3) Delete all contents of this folder4) Restart Power BI Desktop&nbsp;Best Regards,Icey&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

atgeraci · Answer

Hi, I have the same problem. And in fact I just realized it has also impacted my other custom visual that I use - the Chiclet Slicer. So this is more of a custom visual interaction with PBI problem as opposed to a specific custom visual that hasn't been created properly.&nbsp;I tried following Icey's advice but I am currently unable to find the cache location you mentioned (I am very computer literate, I am thinking that doesn't exist for me. I did multiple searches using Search Everything to find the file after trying to navigate to the file manually)&nbsp;Then I hit upon this blog which details how to clear from within the PowerBI Desktop application. Once I cleared it I tried to use the slicer again. This failed as well.&nbsp;Then I found the folder I think you were referencing. The path was this:&nbsp;&lt;system drive&gt;:\Users\&lt;user&gt;\Microsoft\Power BI Desktop Store App\CEFI deleted the cache folder and restarted PBI and... no dice.&nbsp;So then, I got a little bit clever (I think) and I deleted the Hierarchy Slicer custom visual from my report. Closed PBI and then deleted the aforementioned cache folder listed above. I re-opened the report and was met with success! I was able to add in new Hierarchy Slicers!&nbsp;I was still unable to add new Chiclet Slicers though, so I deleted that custom visual next. Closed PBI, and reopened the file and re-imported the visual from the marketplace and that worked too.&nbsp;TL;DR: I am not sure if the deletion of the cache folder is required but I know for sure that for me to make this work deleting the custom visual from the report and closing and reopening and re-importing the custom visual worked. (How to delete custom visuals below)&nbsp;

Forum Discussion

Hierarchy Slicer Not working

4 Replies

Related content

Dynamic Subtitle with Hierarchy Slicers

Slicer and Visualization Hierarchy

Hierarchy Slicer Metadata for Auto Date/Time Hierarchies in Power BI Embedded

Hierarchy Slicer

Date hierarchy