Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
If I have a slicer of fiscal years and a table of data below, is there a way I can adjust the cross filter so that the table shows the "next year" to that selected in the slicer? (i.e. the sliced year + 1)
Thank you,
CW
@PowerWhy , You need to have separate date/year table joined
Next Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])+1))
but this will not show the year on the axis , data will of the next year against the selected year; if you need the year on the axis. You need independent table for slicer
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Year])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Year] =_max+1))
Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE
Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
78 | |
69 | |
69 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |