Matrix Vacation Time

Hello,

So I am currently creating a board that shows when people are away from work. There are multiple reasons why they would be away, hence the different letters. It currently looks like this: 

Some days are missing from the month, but it's fine that it only shows the days that theres activity. 

This is very similar to what I want. But, this only reads the start date (as I only have the start date added in the filter). I'm not sure how to implement the dates in between the start and end date. For example if someone was gone from February 2- June 8 or from April 22-25. 

I have three columns for dates: start date, end date, and range. I'm wondering if I can use the range column to get PowerBi fill in the days? 

I would like it to look something like this:

The top person is away for an extended amount of time (starting in a previous month), so the whole month would be blocked out as vacation. However, from looking at April randomly, you would think they are only gone those two days, which in untrue. 

Any help would be appreciated.