Forum Discussion
Automatic Update of Date Filter
Anonymous
I had a similar situation to show the latest month in the month slicer.
I ended up creating a new column as if last business day =1, then "current" else month_name. Then i used the new column in the slicer and selected "current " as default value. Based on the last business day, the current month is dynamically populated.
You could follow the same approach for all the slicers.
If this helps, mark it as a solution.
Kudos are nice too.
Anonymous
Sarah,
Create a custom or conditional sort order column where values for jan is 1, feb is 2 etc.
Then select the column you want to sort in Data view, then choose "sort by column" drop down to select the column you created in previous step.
If it helps, mark it as a solution.
Kudos are nice too.
Memorable MemberAnonymous
I had a similar situation to show the latest month in the month slicer.
I ended up creating a new column as if last business day =1, then "current" else month_name. Then i used the new column in the slicer and selected "current " as default value. Based on the last business day, the current month is dynamically populated.
You could follow the same approach for all the slicers.
If this helps, mark it as a solution.
Kudos are nice too.
Thank you so much! I will try this...
Hi, VasTg Do you know how to sort the months in order so that it is in order like Jan , Feb , Mar , instead of by alphabetical?
Thank you!
Sarah- VasTg
Anonymous
Sarah,
Create a custom or conditional sort order column where values for jan is 1, feb is 2 etc.
Then select the column you want to sort in Data view, then choose "sort by column" drop down to select the column you created in previous step.
If it helps, mark it as a solution.
Kudos are nice too.
Hi again VasTg , is there a way to put the actual month instead of saying "current"? I feel like it will be more visually appealing if the actual month was displayed...
Thank you for all of your help! (I am new to Power BI)
Sarah