Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello. I want to make a visual the shows how required margin changes over time. The graph I want to illustrate seems to just show a straight line. The reportdate on the x-axis is updating new values daily. How can I fix this issue?
Solved! Go to Solution.
@LFM ,
Your table with dates (Rapportdato) and table with values (2025 - Required Margin, 2026 - Required Margin, 2027 - Required Margin, 2028 - Required Margin) are not connected and hence you are getting a straight line.
You will need to create a relationship between these 2 tables which should resolve the issue.
@LFM ,
Your table with dates (Rapportdato) and table with values (2025 - Required Margin, 2026 - Required Margin, 2027 - Required Margin, 2028 - Required Margin) are not connected and hence you are getting a straight line.
You will need to create a relationship between these 2 tables which should resolve the issue.
@LFM which columns or measures you are using on x-axis and Y-axis, provide more details. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 18 |
| User | Count |
|---|---|
| 192 | |
| 125 | |
| 99 | |
| 67 | |
| 48 |