Forum Discussion
Date Filter
I need help.
I have a bar chart (measure x date (month / year) and I have a date filter to choose only one month. (Eg, I choose January / 2017)
My chart should only show me Measure x Date (until date chosen in the filter). Measurement values for February and March 2017 should be excluded from viewing.
My model has a fact and a time dimension bound by dd /mm/yyyy
I can share my desktop if anyone offers help on skype. You can add me.
my skype is thliberato
Thanks
6 Replies
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.
