cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Strange problem with line chart

Hello all,

I am facing a problem in the line chart visual.. I have a companies profit and loss data, for its 3 branches for 12 months! I have added it up and created a line chart where Y-axis is the value in the account and X-axis is the month. I have added the example of the original data over here.

When I add a line garph for this data, it shows it in a very weird way.. An E is added between the number like its a lograithmic number. Whereas it is not, I have set the decimal points to 2, the Logarithm scale in Y-axis is also off. I don't understand what the problem is! Also when everything is added it sums up as 0.00, when I hover over to the markers it is 0.00 but as you see in this line chart is not 0.00 and the chart is fluctuating, according to the dataset every data point (every month) should be 0.

I have created a slicer for the companies in this case any of the company is not selected.

It would be great if any of you can help me find a solution to this problem.

1 ACCEPTED SOLUTION
Super User

try rounding your value in with ROUND(your value, how many decimal places)

Then try if this will still happen

9 REPLIES 9
Frequent Visitor

Hello all,

I am facing a problem in the line chart visual.. I have a companies profit and loss data, for its 3 branches for 12 months! I have added it up and created a line chart where Y-axis is the value in the account and X-axis is the month. I have added the example of the original data over here.

When I add a line garph for this data, it shows it in a very weird way.. An E is added between the number like its a lograithmic number. Whereas it is not, I have set the decimal points to 2, the Logarithm scale in Y-axis is also off. I don't understand what the problem is! Also when everything is added it sums up as 0.00, when I hover over to the markers it is 0.00 but as you see in this line chart is not 0.00 and the chart is fluctuating, according to the dataset every data point (every month) should be 0.

I have created a slicer for the companies in this case any of the company is not selected.

It would be great if any of you can help me find a solution to this problem.

Super User

try rounding your value in with ROUND(your value, how many decimal places)

Then try if this will still happen

Frequent Visitor

It worked for the chart, thank you so much!

But it is not working for the average line.. I have added it the average line as well and we do not write a formula manually for that so is there a way to have it for Average line as well?

Super User

apply the same in average formula and i think it will also work

Frequent Visitor

@mussaenda I am not writing a formula for it, I am adding it directly from the analysis tab in power bi

Super User

if you are open to create a formula to the average,

you can create a measure for the average the add it as a constant line

Frequent Visitor

@mussaenda  It worked.. Thank you so much 🙂

Super User

Are you sure "." is set for decimal values? Because you may have "," therefore, it won't work properly.

Frequent Visitor

Yes, it is "."

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors