Line and Stacked Column Chart is displaying last numeric column value as X 100% when Shown as Table

Hi, Anonymous 

What’s your method to get the value of [% of Jobs Covered]?

According to your sample picture, I've also created some test data and make a test, and I used a calculated column to get the value of [% of Jobs Covered].

Then I found that the data can correctly display both in the desktop and service.

This is my DAX formula:

% of Jobs Covered =

DIVIDE([# of Covered Jobs],[# of Jobs])

This is my test screenshot:

In service:

In Desktop:

I guess that the “,” delimiter may cause this kind of problem, so I suggest you to remove the “,” delimiter of the column [# of Jobs] and check if it can work:

You can download my test pbix file below

If you still have a problem, you can post your sample pbix file for us to take a test.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.