Date Filter

[thliberato]

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]

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

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]

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]

---

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

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

---

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