Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rounding up Issue

Hi,

 

I have a clustered column chart representing a set of values, however, the graph displays all values as 100%. I do not seem to understand whats wrong. Please see the screenshot attached below:

The original values that Formco Metals should have are: 

80.00 - Jan86.67 - Feb100.00 - March88.57 - April 80.00 - May91.30 - June100.00 - July100.00 - Aug

But the graph displays all values as 100.

 

Please help. 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    The problem is that your monthly values are stored as Text. They need to be a Numeric datatype. Then you will be able to display the values, instead of counts.

    I tried to change to numeric, but there are apparently some "NA" values -

     

    To Do:

    1. Clean up "NA" values by replacing them with null values. 

    2. Change datatypes to Decimal or Fixed Decimal Number.

    3. Re-add the fields to the visual, using the appropriate summarization - "First" should probably work.

     

    Hope This Helps,

    Nathan

7 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    HI, Anonymous 

    If you could what is the field in your Value of this visual. is this like yours?

     

    please check if the Value field is correct. if not your case, could share your sample pbix file for us to have a test?

     

    Best Regards,

    Lin

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for your reply Lin. 

       

      The value field is indeed correct. I'd like to send you the file. Can you please tell me how I can attach/send it to you? I am unable to see an option here.

      v-lili6-msft wrote:

      HI, Anonymous 

      If you could what is the field in your Value of this visual. is this like yours?

       

      please check if the Value field is correct. if not your case, could share your sample pbix file for us to have a test?

       

      Best Regards,

      Lin

       

       

      Please note that I am using the supplier performance from jan - aug. to be represented in power BI using clustered column bar chart. 

       

      Kindly help me fix it. Somehow all the suppliers get 100% even if the actual data is 80s or 90s for each month. 

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        hi, Anonymous 

        From the screenshot, we could not find out the exact cause of it. If there is something wrong with relationship? is the cross filter direction should be "Both"?

        If possible, could you share your sample report for us have a test?

         

        Best Regards,

        Lin