Sorting Stacked Bar Chart by Axis Values

[Anonymous]

Hi Member, 

In the following Graph- I am looking to sort the values on Axis (Screen Time) either ascendingly/ descendingly.

Can anyone suggest how do i proceed. 

[Ashish_Mathur]

Hi,

In the Data Model, it looks like to the screen time column is formatted as a text column.  Change the formatting to Numbers.

Hope this helps.

[Anonymous]

And yes, Ashish- It was formatted as Text earlier.

[Ashish_Mathur]

Hi,

So does the graph now pan out correctly?  If yes, then please mark my reply as Answer.

[Anonymous]

Hi Ashish,

I tried this- to change Text to Column

Changed Data Type udner Formatting from Text to Whole Numbers.

And then, the Screen Time Column started showing #Error for all values and under modelling shows "Cannot convert value '' of type Text to type Integer."

Is there something wrong with my syntax in modelling?

Screen Time = IF('Raw Data'[Status]="Considered",

FORMAT(DATEDIFF('Raw Data'[Application Date],'Raw Data'[Interview Date],DAY),""),

"")

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

Do not write a calculated column formula.  Write a formula in the Query Editor instead

=If [Status]="Considered" then [Interview Date]-[Application Date] else null

[Anonymous]

Hi Ashish,

The graph looks the way i wanted it to, but it is not showing odd values on Y Axis. 

How can i make it plot all values? 

[Ashish_Mathur]

Look at the axis options.  There should be some setting there.

[Anonymous]

Hi Ashish, It did work. Thanks again.

May i know why we used Query Editor and not the Add Column in Data.

[Ashish_Mathur]

You are welcome.  I am sure it can also be solved by using a calculated column.  In a calculated column, you can only have a single data type.