Forum Discussion
Solved
Relations got lost in excel
Hi, I have a data model in Power BI, three tables are related to each other so you can use one table as a slicer on another table. It works fine in Power BI Desktop and Service. But when I export da...
Problem solved 🙂 Filtering through slicer in other table works in Excel only if the value field is not empty. We tested the production solution on pivot table with rows only without any values and that didn´t work. However, as soon as we put ANY field into values, it immediatelly worked. Strange, but true.
Problem solved 🙂 Filtering through slicer in other table works in Excel only if the value field is not empty. We tested the production solution on pivot table with rows only without any values and that didn´t work. However, as soon as we put ANY field into values, it immediatelly worked. Strange, but true.