Is there a way to change a text datatype to a number? Having issues with that. Maybe a way to bypass the error message that a text can't be converted to a number. I've tried advanced editor. Please help. Thanks!
I created a dynamic format for a column in my table to be filtered by a specific slicer. Unfortunately, it is sorting the numbers like they are string. I used the code below:
That's the issue. It is greyed out. Used DAX ro crossfilter column to the slicers but the datatypes are different for all three dropdown options. One is percent and the others are currency. I can't switch them all to the same datatype
Create a dax column to convert text column to number:
text to number = CONVERT([text column],INTEGER)
Then sort by this column to get proper order.
Or create another column besides your [Sales$] column,
then display [Sales$] column on your visual, but sort by the following column
Sales$ 2 = IF ( ISCROSSFILTERED ( 'Parameter'[calculations] ), SWITCH ( TRUE (), VALUES ( 'Parameter'[calculations] ) = "YoY%", SWITCH ( TRUE (), ABS ( [Sales$ YoY%] ) < 1, FORMAT ( [Sales$ YoY%], "Fixed" ), ABS ( [Sales$ YoY%] ) >= 1, FORMAT ( [Sales$ YoY%], "Fixed" ), BLANK () ), VALUES ( 'Parameter'[calculations] ) = "YoY Gap", CONCATENATE ( "$", FORMAT ( [Sales$ YoY Gap], "Fixed" ) ), VALUES ( 'Parameter'[calculations] ) = "Current Year Actuals", CONCATENATE ( "$", FORMAT ( [Sales$ CY], "Fixed" ) ), BLANK () ), BLANK () )
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try padding the "numbers" with trailing blanks so that all text ha same length.
Think like you would do some sort of right alignment
If you search the forum can find a post of mine with the code to do that
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.