The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Experts,
Please can you share the DAX commands or other ways where I can set my filters to default value.
Requirement: Default last 3 year financial years have to be displayed from current date. I have a slicer with Hierarchy and able to display Year, Quarter and month
2. I have to set default to all the filters I have ..
3. I have attached a picture, when I sort the Financial Year are sorting not just the quarters in this. Any help
I created the first filter and I am not able to select as well. Probably I need help. My dates are hierarchical with Financial years. 2. I also need to configure 3 default divisions in division slicer .. almost all my slicers come with default settings 😞 any help is appreciated.
@Anonymous , If no date is selected
//Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date),Date[Date]) //
var _min = eomonth(_max, -36) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
//Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date),Date[Date]) //
var _maxy = maxx(allselected(Date),Date[year])
var _min = minx(filter(all('Date'), Date[year] = _maxy -3),Date[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
If date is selected, then you need independent table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -36) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
30 | |
24 | |
22 |