Forum Discussion

vojtechsima's avatar
vojtechsima
Super User
4 years ago
Solved

Line Chart with Dynamic Vertical Lines (File Attached)

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 
    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.

     

6 Replies

  •  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's avatar
      vojtechsima
      Super User

      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.