Detach line and stacked bar data in combined chart.

[Zepox]

Hello,

I am trying to figure out how to make both the line and stacked bar values independant of each other. The problem in the bottom image is that for example in Week 25 it only shows 3 because there is only data for 3 days in that week in the dataset. The above example is how it should look, where it simply counts the amount of working days within a week, disregarding the actual data from the barchart. I am wondering if this is possible within the visualisation or if I might have messed up my relations (the line and bars are each from a seperate data table).

Kind regards,

[Zepox]

Why the idea of adding the column to the other table has not crossed my mind yet is beyond me. Thank you for your solution.

[amitchandak · Accepted solution]

@Zepox , Then bring working day count from date table(hope week on axis is from date table) 

Assume you have workday column

calculate(sum(Date[Work day]), filter(allselected('Date'), Date[Week] = max(Date[Week]) ))