Forum Discussion
Dynamic sync between dates in filter and dates in chart
Hello!
I need the chart's date to dynamically sync with the date in the filter, whether I choose the "year" level or the "year + month" level.
If I select the "year" level in the filter, this means that the chart will have to display all the months available in the selected year.
If I select the "year + month" level in the filter, this means that the chart should show a breakdown by day of the selected month of the year.
Further examples and details.
1. The starting point. Chart with information for February 2017, broken down by day.
2. The date of the filter has changed, now it is the whole of 2017. And after this selection, the date of the chart was expected to change from a breakdown by day to a breakdown by month.
3. Manually added value "month" to the axis field in the date hierarchy. The chart has now been corrected.
4. In the filter, the date returned the month and after that it was expected to see a breakdown not by months, but by days within the selected month.
1 Reply
- AnonymousNot applicable
Hi bombom ,
I'm afraid it's not supported.
There's a similar featrue in Power BI.
Drill down and drill up in a visual - Power BI | Microsoft Learn
Best Regards,
Jay