Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MarkHP2016
Frequent Visitor

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 created parameters for other columns that copntain just text without any issues, however the columns containing purely numbers are causing an issue

 

Getting the follwing error

 

MarkHP2016_0-1691184416182.png

 

 

I have only shown 2 of the columns to highlight the issue, but i am trying to use many more columns also

 

I have tried changing the format directly in the data source (Excel file) and have also tried to remove any null values

 

Any help appreciated 

1 ACCEPTED SOLUTION

Hi @MarkHP2016 ,

 

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

vrzhoumsft_0-1691478076983.png

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

vrzhoumsft_1-1691478098189.png

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.

 

 

View solution in original post

8 REPLIES 8
parry2k
Super User
Super User

@MarkHP2016 you can share file using one drive/google drive. Cheers!



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@MarkHP2016 This is weird, not sure why? Is it possible for you to share the pbix file, and remove any sensitive information before sharing.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k  - I've tried to private message you.... it wont let me attach the file, says pbix not supported?

Hi @MarkHP2016 ,

 

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

vrzhoumsft_0-1691478076983.png

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

vrzhoumsft_1-1691478098189.png

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
Super User
Super User

@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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@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

MarkHP2016
Frequent Visitor

@parry2k  - The data type of the column(s) is as follows:

 

MarkHP2016_0-1691258885314.png

 

 

parry2k
Super User
Super User

@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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.