Data conversion error

[Anonymous]

Hello,

I'm facing a problem when I am trying to convert my data into a decimal number.

My actual data is tagged as a text but PBI does not seem to take in count that I was using the correct format in Excel before the import.

I have already search for blanks but this is not the issue.

I need PBI to take in count decimal in order to produce diagrams and avoid the field "Count of ..."

How can I solve this ?

Thank you

[Anonymous]

Thank you it is solved. 
Now when I try to do visuals I can not mutualize my data.
Indeed I have two data types in different tables :

- Power which is part of energy table

- Noise which is part of noise table

Therefore I want to mutualize both depending on the collected date but both tables have their own collected date and only one is being printed.

I have already tried to introduce cardinality and manage relationship but it did not work.

[Anonymous]

Hi @Anonymous ,

The question is off topic, please consider creating a new thread to post this question.

If Amit's answer was helpful, please consider marking his answer as the solution, it will help more people find the answer quickly, thanks in advance!😊

How to Get Your Question Answered Quickly

How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak · Accepted solution]

@Anonymous , Open Power Query, Before the first change data type step, use clean and trim

Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4

If needed replacevalues

And they overwrite the datatype step and change datatype to decimal