Forum Discussion
Filter one slicer based on another
Hi ,
I have a fact table, Budget and two dimension tables Fund and DDO, related to fact table in one to many relationship.
I am working on a report and want to filter Budget table based on Fund and DDO.
All I want is when an option is selected from Fund slicer, not only table visual of budget is updated but DDO slicer is also filtered accordingly.
Regards
Make you join bi-directional and try.
click on join properties. There you have the option to make it bi-directional.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
1 Reply
Make you join bi-directional and try.
click on join properties. There you have the option to make it bi-directional.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601