Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rmolinajr
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
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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
Community Champion
Community Champion

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

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.