Forum Discussion
Line Chart with a two axis
Hi guys,
Is it possible to create a line chart like this?
show data label for the first axis and show one or even don't show the data label for the second one in this case is 85%?
Or any custom visuals can do that?
Thanks in advance for any suggestions.
Hi Anonymous ,
Sorry for the late reply. Currently, the best display method can only be as follows. Modifying the measure in Data labels will not display the value of the second data label.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
12 Replies
Anonymous , One of the option is small multiple
https://powerbi.microsoft.com/en-us/blog/announcing-small-multiples-public-preview/
Video -https://www.youtube.com/watch?v=a7PIApvjmVw
You have option enable seconday Axis on Line - That Might not fit here - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart#create-a-combo-chart-with-two-axes
Or you may to explore the Custom Visual - https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
Hi amitchandak, thanks for your reply. Unfortunately mulitple images is not what I'm looking for. The screenshot is actually one chart based on date. It breaks in between because there are some 0 values, and maybe that makes you think it is mulitple image.
Anonymous , Line visual with Categorical Axis Type.
A measure like If([Measure] =0, blank(), measure)
Hi amitchandak, my apologise that I didn't make my question clear.
The screenshot I put there has two lines on the chart. We can see that the data label shows up for each date on the line chart. However for that horizontal line (the green line with value 85%), it only show 85% once, it won't show 85% for each date. Is there a way to achieve that? What happened on my own chart is it shows 85% for each date.
Thank you
Hi Anonymous ,
It can be achieved directly by creating a line chart. According to your request, I created a similar data model, and then just add a straight line to the max point in Analytics.It should be noted that "show items with no data" is checked, otherwise the following error will occur.
If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous ,
This is feasible. The following is my test: I created a measure, added it to the value of the visual, and showed the same result.
If you still can’t solve problem, can you provide relevant sample pbix files or detailed data and information so that I can do an accurate test. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Henry, also I don't see any analytics option for line and clusted column chart and line and stacked column chart. How can we draw the similar charts with those two? (a horizontal line with column charts)
Thank you!
Hi Syndicate_Admin Anonymous ,
You can check if my reply just now can help you solve the problem.
If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
