Forum Discussion
Date Filter
If I understand correctly, I think you can create a calculated column in the time dimension table and use the column in a slicer.
YYYYMM = FORMAT('time dimension'[DATE],"MMM-YYYY")Good afternoon.
Look at the example below.
I would like to select a specific month in the filter and both charts display the history until the selected month.
For exemplo, I select 10-October. 11 and 12 Should disappear from the graph.
thliberato wrote:
Good afternoon.
Look at the example below.
I would like to select a specific month in the filter and both charts display the history until the selected month.
For exemplo, I select 10-October. 11 and 12 Should disappear from the graph.
It should, as long as the date table in the filter has proper relationship with the data table.
Eric_Zhang, this is the relationship.
I did not understand your suggestion to solve the problem.
I want to select a month in the filter, and my chart shows the history until the month chosen in the chart.
Is the visual marked "Filter" a custom visualization? With the standard "slicer" visualization in PBI, you can change it to a date range slider:
In the rop right there will be options of "between", "before", "after" etc. It's not quite as elegant as the Excel-style slicer that you show, but may serve your purposes.
Hope this helps
David
