cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rmolinajr Frequent Visitor
Frequent Visitor

Problem with filter

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.

3 REPLIES 3
dedelman_clng New Contributor
New Contributor

Re: Problem with filter

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.Capture.PNG

Capture2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hope this helps

David

 

 

edhans New Contributor
New Contributor

Re: Problem with filter

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 Frequent Visitor
Frequent Visitor

Re: Problem with filter

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!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 300 members 3,160 guests
Please welcome our newest community members: