Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
98 | |
89 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |