Forum Discussion
Start Date Dynamic vertical line in Graph Visualization
Hello All,
I need a Dynamic vertical line based on Start date As showing in below Image:
Below I am sharing Power BI File link:
https://drive.google.com/file/d/1Hx61gnCCnTy8VdbyBCxPrCqKXeqdoAgB/view?usp=sharing
4 Replies
mohittimpus , I doubt you can get a line like that. If it single measure visual with no legend, you can use conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesamitchandak,
Can you tell me how to apply the Conditional formatting for that, I tried but it is changing color of entire graph.
Hi mohittimpus ,
You could refer to this blog to learn how to add a vertical line.
Or you could use the following formula to create a measure
Measure 2 = IF(MAX('Date'[Date])=SELECTEDVALUE(sheet[Start Date]),5000)And apply it to Values pane like this:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi mohittimpus ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.
Best Regards,
Eyelyn Qin
