Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Sort chart by selection order

Is it possible to sort by selection in slicer? If I select february 2016 to januari 2017 I want to see february in the chart as the first bar on the left followed by march... until january is the last bar in the chart.

 

5 REPLIES 5
BetterCallFrank
Resolver IV
Resolver IV

Hi @Anonymous,

 

can you give us a screenshot of your data?

What data type/columns do you have in your data?

Do you have a date table?

 

without having seen any of your data: you need an additional column, e.g. saying "2016-12", "2017-01" etc - this would be the easiest way to make it sort like you want 

 

HTH,

Frank

Anonymous
Not applicable

I have this:

 

Table Names

Name Created
ABC 2016-02-01 13:12:28
DEF 2016-02-07 11:07:00
GHI 2016-02-07 11:10:52

Then in the chart I have a date-hierarchy on the axis and I have deleted Year, Quarter and Day so Month is the only one left.

 

quick solution would be to add a calc column:

YYYY-MM = FORMAT( Table[Created], "YYYY-MMM")

Then make the new column be sorted by Created column:

Screenshot at Jan. 24 13-07-16.png

 

put the new column on your axis in the visual.

 

HTH,

Frank

Anonymous
Not applicable

When I do that I get this: ("Skapad = Created")

a.PNG

Hi @Anonymous

 

ok, please add a second calc column like this

YYYY-MM-Sort = FORMAT( Table[Created], "YYYY-MM")

(note: only two "M" here in the format) - sort the first calc column by this second column - will work 🙂

 

HTH,

Frank

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.