Forum Discussion
Rounding up Issue
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
Lin,
Please access the file via: https://drive.google.com/file/d/1y832EnzJT4rop_wP6x_4RZEncu2mVsbt/view?usp=sharing
You can see that the actual data is different, but when you select each individual "Supplier ID" from the slicer, somehow the bar graph gives everyone a 100%.
Please let me know if you need more information. Thanks.
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
Thank you very much for your help.
Could you possible help me with denoting the numbers as percentages?
My base excel source has everything in percentage - which translate into plain numbers into power bi. And if I use power bi "percentage" formatting for the numbers, they gain 10^2 (Eg: 100% in excel = 100 in power BI = 10000%).
Is there a way to add percentage just as a unit at the end of original 100 in power bi? I do not wish to change my excel source entirely and have it divide by 100 just so that I can get it right in power BI.
Anonymous - You will need to divide by 100 somewhere. Your options are:
1. In your source
2. In Power Query, select your columns and then divide them:
3. With DAX, you can create new Calculated Columns or Measures.
Hope this helps,
Nathan