Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We have a report where the user selects a single day in the filter to view the charts.
However, in one of the charts, we want to show the evolution of a table column in the last 7 days.
Example:
If user filters by 10/20/2022, the line chart will display the days: (1) 10/20/2022, (2) 10/19/2022, (3) 10/18/2022, (4) 10/17/2022, (5) 10/16/2022, (6) 10/15/2022, (7) 10/14/2022.
Note: We cannot change the filter to relative date or interval, since the other graphs only show the values of the single selected day.
Solved! Go to Solution.
@aroucadaniel , if you select 1 day and want to display more than that on rows /axis the filter/slcier should be on an independent table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -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
@aroucadaniel , if you select 1 day and want to display more than that on rows /axis the filter/slcier should be on an independent table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |