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
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
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.
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
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.