Forum Discussion
Data slicer - Data hierarchy
I tired all of this but wasn't succesful, thank you for helping though. Anonymous
I've been told by someone from Power BI support that it was a bug in an update that they put out last week. (1st week of Feb 2020)
It has since being rolled back and that fixed my issue.
can you further explain what you mean by "fail"?
Right off the bat, I would suggest making sure the formatting is still date when published to Serivce. Other that we will need more information to give you an accurate answer.
Fail as in the slicer does not filter the data. The format is set to date, so that part is okay i think. What other info do you need? Thanks for coming back to me
Hey Anonymous
First, you will most likely need to fix this in desktop and then republish to Power BI Service. Below are my recommendations:
1. Make sure teh relationship between the field in the slicer and the fields in the visual you are trying to slice are active and are many-to-one or one-to-many.
2. Make sure the slicer is still set to interact with the visuals in question. For more information on this see this link: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
3. Delete the visuals and recreate them. This theoretically shouldn't do anything, but I have had this work for me before.
4. If you have other filters or slicers active on the page/visual make sure those do not interfere with the slicer in question.
5. Check to make sure no RLS has been created preventing your access to certain data. Based on your descriptions so far this seems unlikely.
6. Share your pbix file or open a support ticket with microsoft.
If this helps please kudo
If this solves your problem please accept it as a solution
I tired all of this but wasn't succesful, thank you for helping though. Anonymous
I've been told by someone from Power BI support that it was a bug in an update that they put out last week. (1st week of Feb 2020)
It has since being rolled back and that fixed my issue.