topic Re: Line Values with respect to Column series in Developer

Line Values with respect to Column series

Anonymous — Tue, 24 Dec 2019 07:29:52 GMT

Hello,
I am new to Power bi and need to know if line values can be visualized with respect to Column series as circled in the red in the below image. Currently the line values are one over the other.

Re: Line Values with respect to Column series

az38 — Tue, 24 Dec 2019 16:23:12 GMT

Sorry, @Anonymous , I do not see any images below 🙂

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: Line Values with respect to Column series

Anonymous — Wed, 25 Dec 2019 05:28:26 GMT

Sorry, I think the image was not loaded.

Re: Line Values with respect to Column series

v-frfei-msft — Thu, 26 Dec 2019 02:31:47 GMT

Hi @Anonymous ,

Did you mean data labels? For more details, please check the pbix as attached.

If it doesn't meet your requirement, Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Re: Line Values with respect to Column series

Anonymous — Fri, 27 Dec 2019 06:24:39 GMT

Hi @v-frfei-msft ,
Sorry, I did not mean Data labels. I am talking about the markers in the Line value.
Looking into the figure below, I have four line values i.e., Brand1 Budget, Brand2 Budget, Brand3 Budget and Brand4 Budget. All the Budget markers(Dot) are on the one vertical line.

I want the Budget markers to be on each of the respective brands as shown in below image.

Re: Line Values with respect to Column series

dm-p — Sat, 28 Dec 2019 19:42:15 GMT

Hi @Anonymous,

Unfortunately the combo chart doesn't utilise the Legend field for the line series (like the bar does), so any data points for the line will be placed in the middle of the category it relates to, as shown.

In your visual you're also using a different y-axis for your line series, which does not provide a fair comparison to budget and actual.

If you're looking to provide a fair actual vs. budget comparison, I'd suggest using one of the following custom visuals, as they are optimised for this kind of use case and typically make things much clearer for the reader of your reports:

Bullet Chart by OKViz
Power KPI
Zebra BI (has a license cost, but is the gold standard for visualising financials in this manner)

None of these will do exactly what you're asking for in our image but will hopefully allow you to approach the challenge from a different viewpoint.

Good luck!

Daniel