Forum Discussion
Trouble Configuring Date Slicer Interaction for Chart Tooltip
Hello Power BI Community, I’ve been working on a report where I’m trying to display data for a selected monthly period along with a trend visualization. My goal is to show data from the beginning of...
Hi Jarek_Warsaw ,
Based on the testing, please try the following methods:
1.Create the new date table.
Table 2 = CALENDAR(DATE(2023,1,1), DATE(2024,10,9))2.Drag the new table 2 date column to the slicer visual.
3.Create the new measure to filter the date range.
SelectedDate = MAX('Table 2'[Date])TrendMeasure =
var _date = SELECTEDVALUE('Table'[Date])
RETURN
IF(_date >= DATE(YEAR([SelectedDate]) - 1, 1, 1) && _date <= [SelectedDate], 1, 0)
4.Drag the measures into the chart visual Filters pane.
5.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot for your help.
As I understand your solution 'Table' is a fact table, and 'Table 2' is a dictionary table with calendar.
The problem is that my fact table is made from 2 sources:
SalesMTH =
VAR Sales_act = CALCULATE(
SUM('Sales'[Value]),
'Sales'[Attribute] = "direct")
VAR Sales_hist = CALCULATE(
sum('ARCH_Clients'[Value]),
'ARCH_Clients'[Table] = "sales")
RETURN
IF(MAX('DICT_Calendar'[Date]) >= DATE(2024, 1, 1),
Sales_act,
Sales_hist)
How to call a Date from 2 fact tables?