Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am currently using Power BI desktop trial version and when visualising bard charts using excel data, i am unable to re arrange the x-axis in oorder of 10 9 8 7 5. Is it possible to re arrange it in trial version or do we need access to the full version to modify the chart.
Solved! Go to Solution.
Hi @srivatsan34,
What is happening is that the column that you are using for the axis is formatted as text so when you added it to your chart it will give you 10, 5, 7, 8, 9 you need to format the column to number and chose the sort order to Z-A and it will be in the correct format
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @srivatsan34,
What is happening is that the column that you are using for the axis is formatted as text so when you added it to your chart it will give you 10, 5, 7, 8, 9 you need to format the column to number and chose the sort order to Z-A and it will be in the correct format
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix Thank you for your help. What if the column i currently use contains both text and values? So do i need to duplicate this coloumn and format one columna as text and the other column as number?
Hi @srivatsan34,
Add a new column with the following code:
Sort_Order = IF ( NOT ( ISERROR ( 'Table'[Column] + 0 ) ) = TRUE (); CONCATENATE ( REPT ( 0; 4 - LEN ( 'Table'[Column] ) ); 'Table'[Column] ); 'Table'[Column] )
This will convert all your number to 0 added format 10 will become 0010
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |