Forum Discussion
Trouble Configuring Date Slicer Interaction for Chart Tooltip
Hello everyone,
I am working on a report in Power BI where I present data for a selected monthly period. Additionally, I would like to include a trend visualization that shows data from the beginning of the previous year up to the selected period.
I created the following measure:
CALCULATE(
[Sales_MTH],
REMOVEFILTERS(DICT_Calendar),
DATESBETWEEN(DICT_Calendar[Date], DATE(YEAR(MAX(DICT_Calendar[Date])) - 1, 1, 1), MAX(DICT_Calendar[Date]))
)
I also tried using the ALL and ALLSELECTED functions to remove filters, but each time I got the same result: only a single data point for the selected period is displayed.
Does anyone have an idea what could be causing this issue and how I might fix or work around it?
Thank you in advance for any suggestions or advice!
Jarek
On your canvas, if you have the slicer for the date being selected, you can select that visual (the slicer) then go to the Format ribbon, select interactions and turn off teh interaction between your slicer and the chart.
Thank you very much for your help. I feel like I’m getting closer to a solution. After turning off the interaction between the slicer and the chart, I was able to get a chart displaying data for the full available range.
However, I would like to ask if it's possible to reference the selected value in the slicer to set a different filtering range for the chart – for example, from the beginning of the previous year to the selected period.
Also, how can I configure the interaction between the date slicer and the chart in a tooltip?
Thanks again for your help!
