Forum Discussion
Filters have no effect on data
Hi np123,
I've got a database that holds data modeled in the style of a star schema.
A Star schema configuration is usually a central table(Fact table) with several Lookup tables(Dim tables). An example is a Sales actuals table with a lookup table for department.
So in your scenario, you should make the "Fact_Support_Reguests" table as the central table instead of "DimDates" table. Then you can set the cross filter direction to "Both" for the relationships, and the filter will work as expected.:smileyhappy:
For more information about how to create and manage relationships in Power BI Desktop, please refer to this article.
Regards
It sounds like what I'm trying to do isn't possible. The cross filter direction is greyed out when I view the relationship. Having looked online, it appears that this happens because I'm using direct query mode.
I'm trying to create the abilitly to give users a slicer that contains options such as "Currenty Month" "Current Year". My initial thought was to create a view that brought these all together, so that each row in the date dimension can be identified as being in both cateogires.
I cannot relate my relative date table directly to the fact table as I would like to bring in a second fact table at some point, so I can have data from both fact tables in the same report, using the same date filter.
It's looking like I would need a cube in order to give this kind of functionality.