Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a date column which is in the format "Date/Time(General Format) and I have converted it to "Custom Format" like (mmm-yy).
When I drag and drop the date column it was displaying Jan-19 or other values by datewise(taking row context), I need it like when I drag and drop it should display jan-19,feb-19,mar-19 like wise.
Thanks,
Anand
Solved! Go to Solution.
@AnandNamburi ok. since you are changing only the format of the order date, it is showing only month and year. in this case, i would suggest you to add another column in your table like below
Proud to be a Super User!
@AnandNamburi in this case, you need to sort the data in your table. that will ensure that your order is same everywhere. see below screenshot on how to sort by column
Proud to be a Super User!
I have sorted it as you said but in filters it is not working as expected. See screenshots below.
@AnandNamburi can you please share some example or screenshot of your expected output to help you on this.
Proud to be a Super User!
Sure.
Underlying data of this column remains the same as DateTime if you only change its format instead of recalculating the values.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@AnandNamburi ok. since you are changing only the format of the order date, it is showing only month and year. in this case, i would suggest you to add another column in your table like below
Proud to be a Super User!
It worked Thanks. But when I'm dipsplaying the newly created column it is of data type text and it is storing from "A-Z".
Is there any that that I can sort it like earliest month and eraliest year.
Like Jan-21, Feb-21, Mar-21 e.t.c
Thanks,
Anand
@AnandNamburi you can sort you table by month. in the below link you can find solution
https://community.powerbi.com/t5/Desktop/sorting-a-date-table-chronologically/td-p/280635
Proud to be a Super User!
@negi007 this works good in a visualization as I can sort the data on required column. But when I kept the column Month Year in filters it is behaving same. In filter sort options we have AtoZ or ZtoA, no option to select any column specifically. Do we have any workaround for this.