Forum Discussion
TREATAS missing values
Super UserRemove the relationship between the tables on the week column. Create a proper date table and link that to both db1 and db2, mark it as a date table and use columns from that table in your visuals.
Also create an employee dimension table by combining the unique values from db1 and db2 and then link that table to both db1 and db2, again use the values from this new table in your visuals. You could create the table in Power Query or in DAX, sample DAX below
Employee dimension =
DISTINCT (
UNION ( DISTINCT ( 'db1'[Employee] ), DISTINCT ( 'db2'[Employee] ) )
)
Hello thank you for helping me. I have tried your method however there were still missing values. My guess is due to me using TREATAS(?). In order to correctly show score2 based on a name that was selected from bd1, score2 will treat the name selected in db1 as the name selected in db2. Thus if for the particular week score1 does not a value score2 would not be displayed because it was filter based on bd1?
Maybe by forcing the line chart to show all the weeks would solve this how ever my weeks are not in date format thus I cant change their type to categorical.
Tried to click the "show items with no data" but it did not do much.
- johnt75
Are you sure that values are missing? Looking at the table you initially posted, in week 10 there is a value of 100% but there is no value for 5, which is exactly what the chart is showing at week 10.
My apologies, this chart does not show the error for w10
Here is the chart that correspondes to the error, the data of the table on the right is based off this chart.