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

[PSReneKA]

I am coming across an issue with published dashboards not displaying the correct percentage values from a Line and Stacked Column Chart.  The resulting display from a published report is the last column is displaying the last numeric column value time X 100%  instead of the correctly shown percentage value in the visualization's line value.  This is being seen when right-clicking to "Show as Table" on the Line and Stacked Column Chart.

From Power BI Desktop - show as table the last column values shows the correct percent from the line graph:

https://www.screencast.com/t/pSpuGsr9BY 

This workbook has been published to a Premium workspace, and when right clicking to "show as Table"  The last column looks like it is taking the last numeric value times 100% to populate the table's right most column and not display the line values percentage:

More details can be shared if needed.

[v-robertq-msft]

Hi, @PSReneKA 

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.

[ranbeermakin]

pls share more details... is the DAX correct?