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!
I'm trying to add a date slicer to the dashboard, so the dashboard will present data from the last/next three months.
I add columns with calculated dates and tried to add them to the filter in the slicer options, but it doesn't work. The dashboard still present data from other dates.
How does it possible to add default values to a slicer?
Thanks in advance,
Solved! Go to Solution.
Hi @rossnruthie,
Based on my understanding, you can create a calendar table. Create calculated column to get Year, Month,Week.
Year = YEAR(Test[Date]) Month = MONTH(Test[Date])
Second, create tree measures using the formulas.
last/next three month = CALCULATE(MAX(Fact[value]),FILTER(Fact,(Fact[Month]<=MONTH(MAXX(ALL(Test),Test[Date]))+3)&&(Fact[Month]>=MONTH(MAXX(ALL(Test),Test[Date]))-3)))
Third, create a new table including the values and the[last/next three month] value.
If this is not what you want, please share your sample table for further analysis.
Thanks,
Angelia
Hi @rossnruthie,
Based on my understanding, you can create a calendar table. Create calculated column to get Year, Month,Week.
Year = YEAR(Test[Date]) Month = MONTH(Test[Date])
Second, create tree measures using the formulas.
last/next three month = CALCULATE(MAX(Fact[value]),FILTER(Fact,(Fact[Month]<=MONTH(MAXX(ALL(Test),Test[Date]))+3)&&(Fact[Month]>=MONTH(MAXX(ALL(Test),Test[Date]))-3)))
Third, create a new table including the values and the[last/next three month] value.
If this is not what you want, please share your sample table for further analysis.
Thanks,
Angelia
Hi,
You could try making a column that reflects the time diff between the date you wanna check, and "now()", and then apply filters that force it to be up to +-90 days. I use this formula:
Collections Delay =
SWITCH (
TRUE ();
Now() < Invoices[Overdue Date]; DATEDIFF ( NOW();Invoices[Overdue Date]; DAY )* -1;
Now() > Invoices[Overdue Date]; DATEDIFF ( Invoices[Overdue Date]; Now(); DAY );
0)
So, if this is between -90 and +90, only data from that period will be shown.
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |