Forum Discussion
undefined
- I have goss,net amount and discount column in data need to show unti wise discount % as a bar graph. But my value is not matching with excel data source when i try to give formulas
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Prashanth1403 ,
Based on your description, here are a few suggestions to help you troubleshoot the problem:
1. Please check whether the formula written in power bi is correct and consistent with the logic in excel. The dax formula is different from the formula in excel, please make sure you write the correct dax formula.
2. Please ensure that the data types in power bi and excel are consistent. If the data types are inconsistent, different results may result.
3.Power Bi will automatically format the results, and you can manually select the % button to correctly display the percentage results.
If these cannot help you solve the problem, you can provide more detailed pbix files or screenshots to better help you solve the problem.Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
