Line Chart with Dynamic Vertical Lines (File Attached)

[vojtechsima]

Hello guys,
I'd like to have the following chart:

One continuous line with Sales Performance and then dynamic lines that would show me when the user attends training.

I have issues displaying those lines, for each user it can be different so I need a dynamic solution. 

I am attaching pbix file with the needed model.

Could someone please advise me on how to do it properly?

[lbendlin]

 for each user it can be different

Are you expecting to control this via RLS, or USERPRINCIPALNAME by itself? Outside of these option Power BI would not know which user is looking at it.

[vojtechsima]

@lbendlin 
well not really, I would use Single Select Slicer.

Please note, I need to use Year, Month hierarchy and with that I am only able to get workaround like this, but I need the columns to be way thinner, as this doesn'T look that great.

[lbendlin]

This seems to work - please check.

[vojtechsima]

Thank you.
I was able to re-create this workaround as well using the Date column.
But it's not really applicable as I need to use the Year, Month hierarchy.

Any other idea? @lbendlin 

[lbendlin]

I think it is acceptable on Month level.  For year level a table visual may be more appropriate.

[vojtechsima · Accepted solution]

@lbendlin 
Yea, I am tied with the visual.
But I found a workaround, when I put a similar measure there and hide it, it looks thinner.

It's not the best solution but it works.