Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm looking for a date slicer (see below proof of concept)
See picture here: https://stackoverflow.com/questions/66075440/is-it-possible-to-create-a-custom-date-slicer-on-power-...
The main features should be:
-The selection is aggregated by month
-The text on top of the slicer should have the month and year just like how its illustrated above.
Any guidance on creating custom visualisations is appreciated!
Solved! Go to Solution.
Hi @mmishal001
I think you want to use the option of Timeline slicer and you want to show MMM-YY in cells instead of only month in cells.
However it is not support in Timeline slicer, you can only add date type value into this slicer.
So if you use format function to build a new column with type of MMM-YY, it will show blank.
Try to turn on Display all in Lables. Year will show above the month.
If you still want to show MMM-YY, please try to use slicer visual and add you need to build a yearmonth column to sort the text type column.
MMM_YY = FORMAT('Date'[Date],"MMM-YY")
YearMonth = YEAR('Date'[Date])*100+MONTH('Date'[Date])
MMM_YY is text, and sort this column by YearMonth(Whole number).
Use Ctrl+left click to do multipe selections.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mmishal001
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi @mmishal001
Create a columns as
MMM_YY = FORMAT('calendar'[Date],"MMM-YY")
for the slicer and download the below slicer from marketplace and use it.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
thanks @pranit828
This is the closest I could get - is there a way to add the year in addition to the three letter month name ("Nov-19" and not just "Nov")
HI @mmishal001
Create the new column using DAX formula I mentioned in my previous post.
MMM_YY = FORMAT('calendar'[Date],"MMM-YY")
Now, use this column in the timeline slicer.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I did. And at first it was blank (maybe because the format was text)
I then changed the type to date format and it gave me the above result.
HI @mmishal001
Try
MMM_YY = LEFT('calendar'[Date].[Month],3) & "-" & RIGHT('calendar'[Date].[Year],2)
Or I can alreay see there is a column you have as "Month Year", use that.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
It's blank - tried existing column as well as the new column
Hi @mmishal001
I think you want to use the option of Timeline slicer and you want to show MMM-YY in cells instead of only month in cells.
However it is not support in Timeline slicer, you can only add date type value into this slicer.
So if you use format function to build a new column with type of MMM-YY, it will show blank.
Try to turn on Display all in Lables. Year will show above the month.
If you still want to show MMM-YY, please try to use slicer visual and add you need to build a yearmonth column to sort the text type column.
MMM_YY = FORMAT('Date'[Date],"MMM-YY")
YearMonth = YEAR('Date'[Date])*100+MONTH('Date'[Date])
MMM_YY is text, and sort this column by YearMonth(Whole number).
Use Ctrl+left click to do multipe selections.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@mmishal001 using chicklet slicer you can have the kind of visual you are looking for. Follow below steps
1. If you have a calender or date table, please create a column like below
then using get more visual, import the chicklet slicer in your powerbi dataset and use the column created in step1 in this slicer
let me know if it helps you. thanks
Proud to be a Super User!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |