Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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.

Need Help

2 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.