Hi All
Complete novice with Power BI but learning!
My immediate problem is that i have one central data table, to which ive attached by custimer id code, 2 satellite tables containing client markers A or B, but not all customers in the satellite tables are present in the central data table; and nor are there duplicate customer id's in the 2 satellite tables.
My existing visual is a simple list of customers deatails from the central data table and works fine as there is nothing complcayed about it. However I need the visual to show the markers against each customer where applicable, and where there is no marker the visual should show "Missing".
On dragging the marker from the first satellite table to the visual, the list is reduced to only those cases that are in both tables - because apparently thats how Power BI works.
Being a novice i cant query that opinion and have been told i need to create a measure, hence my query here. How do i make sure that the visual shows every record that matches in either satellite table, is returned with the appropriate marker from the satellite tables, and those that dont match anywhere comeback with a "Missing" value.
All/any help would be gratefully received !
Simon
Complete novice with Power BI but learning!
My immediate problem is that i have one central data table, to which ive attached by custimer id code, 2 satellite tables containing client markers A or B, but not all customers in the satellite tables are present in the central data table; and nor are there duplicate customer id's in the 2 satellite tables.
My existing visual is a simple list of customers deatails from the central data table and works fine as there is nothing complcayed about it. However I need the visual to show the markers against each customer where applicable, and where there is no marker the visual should show "Missing".
On dragging the marker from the first satellite table to the visual, the list is reduced to only those cases that are in both tables - because apparently thats how Power BI works.
Being a novice i cant query that opinion and have been told i need to create a measure, hence my query here. How do i make sure that the visual shows every record that matches in either satellite table, is returned with the appropriate marker from the satellite tables, and those that dont match anywhere comeback with a "Missing" value.
All/any help would be gratefully received !
Simon
