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.
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
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 |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |