Forum Discussion
Dynamic date vertical reference line for scatter chart
That's a very difficult issue Anonymous . Is your line fixed at a specific date or does it vary based upon slicer selection? I'm not sure it matters but want to ask. Bubble charts do not have Analytics enabled so can't go down that route. Only thing I could think of would be to manufacture points for your bubble chart for many values of Y for the same X and then UNION that onto your table or whatever you are using for your bubble chart but that is a long shot and would require specific circumstances.
Sample data and such could help determine if this is possible. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Community ChampionThat's a very difficult issue Anonymous . Is your line fixed at a specific date or does it vary based upon slicer selection? I'm not sure it matters but want to ask. Bubble charts do not have Analytics enabled so can't go down that route. Only thing I could think of would be to manufacture points for your bubble chart for many values of Y for the same X and then UNION that onto your table or whatever you are using for your bubble chart but that is a long shot and would require specific circumstances.
Sample data and such could help determine if this is possible. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg_Deckler , thanks so much for your reply! The line is fixed at a specific date.
I will try your proposed solution and see what happens. I had a similar thought when I created a line in a seperate scatter chart using dummy values. I'll be sure to update this thread with the results and sample data if needed.