Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
So, we are using a line chart to show a yearly trend.
2025 and 2026 are the 2 lines which we are plotting in the line chart.
There is an issue in the position of data labels.
BLUE LINE->2026
GREY LINE->2025
The requirement is that lower values should come below the line and higher value should come above the line.
For example, let's consider Week 2 ,27.7 should come below and 29.2 should come above the line.
To keep it simple, it should be opposite to how it is shown in this picture.
I can achieve this by adjusting data label position, I can keep 2026 line as Under and 2025 as Above.
But, then if we consider Week 5, the value of 2026 is more than 2025 in this week.
Since I have kept 2026 as under, 42.3 will come below and 39.8 will come above.
I have tried all combinations in modifying the data labels position and I have tried Auto position as well.
Atleast in one of the weeks, the label position always gets misplaced.
Any suggestions on this?
2025 | 2026 | |
Week 1-> | 21.4 | 15.8 |
Week 2-> | 29.2 | 27.7 |
Week 3-> | 34.2 | 33.6 |
Week 4-> | 36.7 | 38.2 |
Week 5-> | 39.8 | 42.3 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
87 | |
80 | |
53 | |
40 | |
39 |
User | Count |
---|---|
102 | |
85 | |
47 | |
46 | |
44 |