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.
In the matrix columns, I need to show data for the next 7 months from the selected period in the slicer.
Period value is an integer in YYYYMM format
I have 4 tables:
Years [Year]
Months [Month, MonthName]
Periods [Period, Year, Month]
Sales [Period, Product, Amount]
Periods and Sales tables have a relationship via the Period field.
Years and Months tables are independent.
In matrix Columns settings I selected the "Show items with no data" option to show all months even if there are no sales.
Because the Periods table has no relationships with Years and Months tables, slicer selections do not affect Period columns in the matrix.
If I build a relationship between Periods and Years and Months tables, then a matrix shows only a period column for a selected Year-Month.
How can I show the next 7 months starting from the selected period and ending 7 months after the selected period?
@elshadlive , when you need more then selected value in visual the slicer needs to be on an independent date table
example
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max1 = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max1, -1) +1
var _max = eomonth(_max1,7)
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
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 |
---|---|
87 | |
86 | |
68 | |
65 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |