Power Bi Relationship

[Satyam7054]

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?

Power Bi file 

[Satyam7054]

Another Screenshot

[Satyam7054]

@rajendraongole1 Thank you for your prompt response,

However, the issue still persists. I am sharing a screenshot with you to provide a better understanding of the problem. Additionally, I will share the excel dataset with you as well.

https://parmarthsanstha-my.sharepoint.com/:x:/g/personal/satyamchaturvedi_parmarthsanstha_in/ETKiBt0... 

[rajendraongole1]

Hi @Satyam7054 - Yes, i have analyzed the file shared. i have taken example for a date highlighted 17-03-2024

Getting the below result when i select the date and project name as per below snapshot:

Model FYR: Changed the relationship from Drinking water works to Project master table.

Above is the expected output as per shared excel file. we are getting. 

Kindly let me know if that works, if not kindly share what is expected from your end on date level or project master wise.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Satyam7054]

Hi @rajendraongole1 Ji Thank you for your assistance so far, but the issue still isn't resolved. Now, it cannot filter by Village Name, and the Project filter is also not appearing.

I want to create relationships among all the tables in my Power BI file, making the Project Name and Date slicers the master slicers. This will allow me to filter different tables' projects along with the timeline simultaneously.

For example, I want to create a dashboard where each table contains some data. I want to filter this data using both the Project slicer and the Date slicer.

[rajendraongole1]

Hi @Satyam7054  in such scenerio, use project name from Project master table in all the visuals, and date table has to create seperately. (hope it is created). 

Take the reference of Village name column from Grassroot_Cadre_Database table, as it is having right relationships with other tables too. 

Check the count of villages as per selection of project name and date, it is validated that total count is 49

Please check the model build as below:

Hope it works, Thank you

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Satyam7054]

Hi @rajendraongole1 JI Thank you for the continued assistance with this issue. However, the filtering is still not working correctly. Here are the specific problems:

1. The Count of Project Name card, which is sourced from the Drinking Water table, shows 1 entry on the dashboard when applying the SSI Project and Date filters in Power Query shows no entries.
2. The Count of Member Name card, which is sourced from the Grassroot Cadre table, should show only 2 entries when filtered by Project Name and Date in Power Query, but the dashboard displays 493 entries. Additionally, the Count of Village Name should only have 1 entry.
3. The Count of Activity card sourced from the Village Level Meeting table is the only one where the filter works correctly.

I am sure you understand the issue now. If there is any other way to resolve this problem, please let me know. I have already created a Master Project and Master Date table and connected them to all relevant tables, which you should be able to see in the mapping.

Please advise on any alternative solutions or corrections that can be made to fix this issue.

for more clarity please see screenshot

[rajendraongole1 · Accepted solution]

Hi @Satyam7054 - Please find the following comments:

1. The Count of Project Name card, which is sourced from the Drinking Water table, shows 1 entry on the dashboard when applying the SSI Project and Date filters in Power Query shows no entries. --> Please check in Table view not power query editor.

In data view i have filtered with above combinations. we are getting only 1 project name from Drinking water table with mentioned filters. SSI and 17th May 2024 date.

you have to build inactive relationship between tables too

eg: 

I have created for VillageName,membername

Village name count = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Village Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))

membername count relation = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Member Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))

visuals are coming as available data results.

you have to check on the model part. please work on it, if require build the inactive relationships and bring the right values to your visualization using DAX functions. 

I hope it works. please check

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Satyam7054]

Hi @rajendraongole1 

This is working. Thank you so much for your assistance. I will reach out to you if I face any other issues in the future. Thanks ones again. 

Satyam

[rajendraongole1]

Hi @Satyam7054 - Just checked your model, can you change the relationship between two tables as below:

instead of Grossroot Table--> Date table

Just verified i can able to filter both project name and date simultaneously and data is getting changed as per backend dataset.

Please change the above and let know

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!