Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
what I would like is for that 80% line to go across the chart in a straight line, but instead its doing something else even though the percentage value is there
any idea what is going on
Solved! Go to Solution.
Use a standard column chart and use the "Analytics" pane to add a constant line
For other users that will be having this same issue.
The solution is for you to turn off the "Show Secondary" under the Y axis
expand the Y axis, and scroll down
Then, turn off the "Show Secondary" . That's all
I created a measure ike this "TAT KPI = 10" for the KPI that i needed to be visible.
and it looks like a straight line "line and clustered column chart" where Analytics page is not available.
standard bar chart wasn't it for me.
Use a standard column chart and use the "Analytics" pane to add a constant line
Brilliant! Why is the Analytics pane not more widely documented? I have been using Power BI for 3 years now and this is the first time I have seen an article when it is useful for me. No more... This will be in my toolbag from now on
Thank you. This is EXACTLY what I needed. This has driven me nuts for days, and all that time it was sitting in the analytica tab (how intuitive of microsoft to put it there ! )
@jimmy09 For other users that will be having this same issue.
The solution is for you to turn off the "Show Secondary" under the Y axis
expand the Y axis, and scroll down
Then, turn off the "Show Secondary" . That's all
@jimmy09 Not sure if you figured it out. To create that chart you have to use the line and clustered column chart.
Agree with dedelman_clng. A constant line through "Analytics" Pane would be a solution here.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
98 | |
41 | |
38 |
User | Count |
---|---|
153 | |
123 | |
80 | |
73 | |
73 |