Forum Discussion
Calendar slicer for visuals based on multiple tables.
Community SupportHi Anonymous ,
Based on your description, it seems a bit vague. Can you provide the relevant screenshot information and describe it so that I can answer it for you as soon as possible?
If you want to implement a slicer to filter a specified list, you can try using the following function.
Power BI - Edit Interactions features - Power BI Docs
For similar circular dependency problems, you can refer to the following solutions.
Solved: "A circular Dependency was detected" error while c... - Microsoft Power BI Community
Solved: Circular Dependency Error - Microsoft Power BI Community
Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for taking the time to respond to my topic.
I actually managed to find a solution on my own, but I will try to clarify the issue I was having and post my solution, maybe it can help someone else with a similar problem. I won't be providing screenshots of the visuals due to them containing sensitive data (names etc).
I wanted to have a Date hierarchy slicer (Year/Month/Week) that would filter my visuals based on three different sharepoint lists. The problem I was having was that only one of the lists had a date field (the list containing daily tasks), with the other two having a calculated Week and Month columns (generated through PowerApps) as numbers.
What I ended up doing was using the Created column on the weekly/monthly lists to calculate the first day of the week/month respectively, and creating a relationship between those columns and my calendar table.
Relations between my Calendar table and SP Lists
I'm sure there is a better solution, but due to my minimal experience with Power BI this is the one I managed to come up with 🙂