Forum Discussion

xinlinl's avatar
xinlinl
Frequent Visitor
2 years ago
Solved

Power BI visual vs Data Source values

Hi,    I have an excel storing in sharepoint as my data source to use in my Power BI report. Within the excel file, it performs calculation of summarization for some columns (eg. column A1:L1) in a...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, xinlinl 

    The values on some visuals are different than you expect. This may be related to the data type, calculation method, or formatting.

    You can try these possible solutions:

    1.Decimal place setting: In Power BI, you can manually set the decimal places for column charts.

    2.Try using DAX functions. For example, you can use the ROUND function to ensure that a number is rounded to the number of decimal places you want. For example, ROUND(YourValue, 2) rounds a number to two decimal places.

    If you haven't solved the problem yet, can you provide a sample that doesn't include privacy? I will try to give you further reply based on the sample

     

     

     

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, xinlinl 

The values on some visuals are different than you expect. This may be related to the data type, calculation method, or formatting.

You can try these possible solutions:

1.Decimal place setting: In Power BI, you can manually set the decimal places for column charts.

2.Try using DAX functions. For example, you can use the ROUND function to ensure that a number is rounded to the number of decimal places you want. For example, ROUND(YourValue, 2) rounds a number to two decimal places.

If you haven't solved the problem yet, can you provide a sample that doesn't include privacy? I will try to give you further reply based on the sample

 

 

 

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.