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.
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.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |