Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
I'm very new to Power BI and I'm creating a report
I've a Text column where Numberic and Non Numberic data is present.
Ex: The column value contains:
2,3,5,9,13,15,78,89,Completed,255,230,Completed,3,5,18
And I've to put this in a chart segregating numeric and non numeric data (counting number of numeric data and non numeric data)
The graph should contain:
13 - Numeric
2 - Completed
Solved! Go to Solution.
hi @Anonymous
You could create a new calculated column as below:
https://docs.microsoft.com/en-us/dax/value-function-dax
Type = IF(ISERROR(VALUE('Table'[Column1])),'Table'[Column1],"Numeric")
Then drag this new column and basic column into a visual and set Column1 is "Count"
Result:
and here is sample pbix file, please try it.
Regards,
Lin
hi @Anonymous
You could create a new calculated column as below:
https://docs.microsoft.com/en-us/dax/value-function-dax
Type = IF(ISERROR(VALUE('Table'[Column1])),'Table'[Column1],"Numeric")
Then drag this new column and basic column into a visual and set Column1 is "Count"
Result:
and here is sample pbix file, please try it.
Regards,
Lin
@Anonymous ,Can you let us know how data looks in tabular format.Can you share sample data and sample output.