Re: Date Filter

thliberato · ‎03-08-2017

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

Eric_Zhang · ‎03-08-2017

@thliberato

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")

thliberato · ‎03-09-2017

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.

dedelman_clng · ‎03-13-2017

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

Eric_Zhang · ‎03-12-2017

@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.

@thliberato

It should, as long as the date table in the filter has proper relationship with the data table.

thliberato · ‎03-13-2017

@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.

Eric_Zhang · ‎03-22-2017

@thliberato wrote:

@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.

@thliberato

Could you post a sample pbix for testing?