The Actual Values not the count of values decimal numbers in the column (like 0.001, 0.002, <0.007)

[sikhaharsha06]

Hi,

I have 2 columns one is date (Date Format) and other is Results is Text format because results column values looks like example:  (0.001, 0.007, <0.003, <0.007, <0.025, 11, 52). It has less than symbols and normal decimal values and normal numbers

Now, I want a chart to show Actual values(Not Count) by Date ( For example I have a slicer of Client name. If I select Client name in the slicer, I need to get all of his ACTUAL RESULTS by Date) 

Thanks

[amitchandak · Accepted solution]

@sikhaharsha06 , You have to create a decimal column by removing > and < in power query or replacing them with some value and then you can do sum of Avg of the numeric column

[sikhaharsha06]

Hi Amit, But How can I show only the actual values (Original Values) Not the sum or Count. 

How can I show Actual Original values by date, When I select a client in the slicer.