Forum Discussion
Implementation of Left Join Scenario in Table Visual
Below is my scenario :
Fact table :
Dim table :
There is 1:1 relationship between the dim and the fact table.
Now my requirment is to display all the columns and rows from dim table and the sum of hour for the the coressponding join if any else blank for the latest month.
Output needed in table visual:
MonthCd ,EmpId,Gender,Country,Hours
20240301,1,M,USA,8
20240301,2,F,UK,blank (or even 0)
20240301,4,,UK,7
20240301,5,M,India,9
But when I pull in the measure of sum of hours from the fact table in the dim data, as ROw with ID 2 is not present in fact for the latest month, hence the dim row also gets filtered out
So how to retain the row when there is no fatual data assoacited with it be replacing it with blank/null/default value?
Have attached sample PBIX file for reference
Hi NandanHegde ,
In this case you only need to go to the visualzation and select the show items with no data option:
1 Reply
- MFelix
Super User
Hi NandanHegde ,
In this case you only need to go to the visualzation and select the show items with no data option: