Power Bi Relationship

[Satyam Chaturvedi]

Hi,

I am sharing a Power BI file where there are multiple tables, each containing unique Project Name and Date columns, which are consistent across all tables. I am trying to create a dashboard using data from these tables. However, I am facing issues filtering all tables together based on Project Name and Date. I have created separate tables for Project and Date, but I can only filter all tables using either Project or Date, not both simultaneously. When I try to filter using the second slicer, the results are incorrect.

I need to filter based on both Project Name and Date, so that I can fetch data from various tables and filter using both slicers effectively. Can someone help me with this?

file URL - Master_MIS_power.pbix

 

[GraH - Guido]

Maybe this isn't what we call a star schema?

You should have a single fact table (with project actuals, etc) and around it some dimension tables and a single calendar table. Your required slicers are a hint.

In short, your data is not ideal to work with. Normalize and standardize is the mantra.