Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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:
put the new column on your axis in the visual.
HTH,
Frank
When I do that I get this: ("Skapad = Created")
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |