Problem with filter

[rmolinajr]

Hi,

I'm with problem in a solution, the problem:

I put a filter of date and a graphic, the database exists the date 2012-01-01 to 2018-12-31, the idea is the following, when put the filter of date 2017-01-01 to 2018-12-31, in the graph will appear the years 2018, 2017, 2016 and 2015, but I can not show it in the graph, is there any way to do this?

thank you!

Roberto Molina Jr.

[edhans]

You would need the measure you are using to populate the graph to include an ALL() function to exclude the impact of the visual, or you could change the interactions for the graph to ignore the slicer. That is found in the Format|Edit Interactions menu of the Desktop app.

[rmolinajr]

Hi,

I did this, but it does not work, because if I remove the filter interaction, I can not get the maximum of the date chosen by the filter, if I leave the filter interaction, the filtered years appear, below I'm leaving the dax code I'm using.

CALCULATE(
[VALOR TOTAL];
FILTER(
ALL(Tabela);
Tabela[Data] >= DATE(YEAR([MAX_DATA])-3;1;1) &&
Tabela[Data] <= DATE(YEAR([MAX_DATA]);12;31)
)
)

MAX_DATA = MAXX(ALLSELECTED(tblSipCcoLancamentos[Data]);tblSipCcoLancamentos[Data])

Thank you!

[dedelman_clng]

I think this is what you're looking for:

Make sure your X-axis is only year (this will not work with hierarchies), and that it is marked as Continuous (so it is being treated as a number). Then set "Start" to your minimum required date.

Hope this helps

David