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:
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
Go to Solution.
You could create a new calculated column as below:
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"
and here is sample pbix file, please try it.
View solution in original post
@Muhammed ,Can you let us know how data looks in tabular format.Can you share sample data and sample output.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.