Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |