Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi,
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!
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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |