Forum Discussion
Cross table filtering
Hi, I am having an issue establishing a relationship between two tables, and including a cross page/report filter. For some reason, even though both attributes are based on Month level (e.g Janua...
You can create a helper column that would generate the Primary key for relationships to establish.
It is neccessary to have Primary and Foreign Keys in Tables to create relationships.
You can read more on this at below Blog.
Must Read: It is by Jeffery Wang ( The Microsoft PowerBI Genius)
https://pbidax.wordpress.com/2015/11/04/handle-complex-relationships-inside-power-bi-desktop/