Forum Discussion

MarkHP2016's avatar
MarkHP2016
Frequent Visitor
3 years ago
Solved

Help creating Parameter - Text will not convert to number

Hello,    I am trying to create a parameter, using multiple columns containing numbers, this being able to use slicers visually to show these figures against values in other columns   I have crea...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi MarkHP2016 ,

     

    Here I create a sample to have a test, however I couldn't reproduce your issue.

    Source = {
    ("Source - AAAAAAAAA",NAMEOF(Table1[Source - AAAAAAAAA]),0),
("Source - Before of  the maintence BBBB",NAMEOF(Table1[Source - Before of  the maintence BBBB]),1)
}

    Please share a sample file with me and show me a screenshot with the result you want.

     

    Best Regards,
    Rico Zhou

     

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

     

     

parry2k's avatar
parry2k
Super User
3 years ago

MarkHP2016 in your new screen shot, you are not showing the column that you used in the original parameter, so not sure what is the type of those columns.

MarkHP2016's avatar
MarkHP2016
Frequent Visitor
3 years ago

parry2k  I've used different columns, but they are just different columns relating to the same problem, on my original screenshot i only used 2 columns to show an example, but the whole issue is for many columns, all with essentially the same type of data

 

They all contain values (numbers) that are generated from a Vlookup in Excel