Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, I need to add a dynamic, vertical reference line to my scatter chart. My scatter chart has a date (in whole number format) x-axis and a numeric y-axis. Looks like this unfiltered:
I need to give my boss a scatter chart that has a vertical reference line that indicates the last date an event occured, this date is in the dataset. It should look something like this: (I overlayed two visuals to illustrate.)
I can't overlay two visuals as the final solution because if someone uses the slicers on my page the scatter chart axis will change and the line will not adjust properly, I've tried.
Any help is greatly appreciated!
Solved! Go to Solution.
That's a very difficult issue @dtipton . 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
That's a very difficult issue @dtipton . 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.
The union suggestion works! I have some complex filter logic applied to this report and the line still appears. For anyone who has a similar need, here is what I did.
1. Create a seperate table for generating values for your line. Here is the code I used:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
29 | |
14 | |
11 | |
10 | |
9 |