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
Icon for Super User rankSuper User
3 years ago

MarkHP2016 the two columns you have shown here, what is the data type of these columns? Keep in mind data type and format are two different things. When I asked about data type I mean what is the type of the column in the Power Query?

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo