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.
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 @Muhammed
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 @Muhammed
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
@Muhammed ,Can you let us know how data looks in tabular format.Can you share sample data and sample output.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |