Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
In my source table I got 2 date columns.
PeriodCode = 201601, 201602, 201603 ....201612
PeriodName = Oct2016, Nov2016, Dec2016....Sep2017
Where 201601 corresponds to Oct2016 as that's when our company financial year starts.
In the slicer, I want to show PeriodName but sort it by PeriodCode rather than it sorting itself alphabetically. How can I achieve this please?
Thanks much.
Solved! Go to Solution.
Hi @Sdutta,
You should sort your column by the PeriodCode and then you will get the information as you want.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Sdutta,
You should sort your column by the PeriodCode and then you will get the information as you want.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsAbsolutely perfect, thank you so much.
Having worked in SSRS for years, I am just a bit slow in getting used to Power BI way of dealing with these things.
Regards
SDutta
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |