Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a date column with YYYY/MM/DD
I have seen a slicer to the visualization look like this one below.
2010/2011
2011/2012
2012/2013
2013/2014
etc....
Anyone knows how I can do it?
Try this calculated column formula
New Year = YEAR ( Date[Date] ) & "/" & YEAR ( Date[Date] ) - 1
Or
New Year = YEAR ( Date[Date] ) - 1 & "/" & YEAR ( Date[Date] )
You can then use this column to create a slicer, hope this helps
Thanks
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |