- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 01:21 AM
Hi all,
I have a slicer in my report for Year. Most of my visuals need to be filtered on that year, which of course works just fine. However, I have one chart for which I want to show a sum per year for all years BEFORE the selected year. In other words, if the user selects 2017 in the slicer, my chart should show data for 2014, 2015, 2016 (or whichever years I have data for, but only up until 2016). Is this possible?
Thanks in advance!
Solved! Go to Solution.
Accepted Solutions
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-21-2017 03:54 AM
HI @betski,
Has been testing several scenarios but do not now how your data is fully set up. But check if this post can help you.
https://community.powerbi.com/t5/Desktop/Slicer-reverse-selection-in-chart/td-p/96316
Regards,
MFelix
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
All Replies
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 01:31 AM
Hi @betski,
If you select the slicer then on the top bar select the modeling and then the Edit Interactions all of the visuals will show three options: filter, highlight, do nothing. chose the do nothing (forbidden sign) and filter your visual direcly. The image below shows an example.. Th
Regards,
MFelix
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 01:48 AM
Hi @MFelix and thanks for your reply! Not sure how I would get the filter on the chart to be correct, though... I don't want to hard code it, it should depend on the value in the Year slicer. If the user selects 2016 in the slicer, the chart should show data up until 2015, if they select 2015, the chart should show data up until 2014, etc.
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 01:57 AM
In that case you have to make a measure and used it in your visual.
Questions:
Do you use a measure or a column in your visual that summarizes?
Where does the year comes from? A date table?
Regards
MFelix
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 02:10 AM
The year comes from a time dimension in my tabular SSAS. The chart summarizes a measure (invoice amount) by year (in the time dimension). How do I make a measure to use for this - I will not know beforehand what year the user will select in the slicer?
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 03:16 AM
Can you please show me how your measure invouce amount is calculated?
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-20-2017 03:54 AM
There is no special calculation - it is a simple measure added directly from the fact table, summarized per year in a stacked column chart (Time on the axis and Invoice Amount as Value). All I want to do is to add a filter on year saying that the chart should contain only years earlier than the selected value in the Year slicer.
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-21-2017 03:54 AM
HI @betski,
Has been testing several scenarios but do not now how your data is fully set up. But check if this post can help you.
https://community.powerbi.com/t5/Desktop/Slicer-reverse-selection-in-chart/td-p/96316
Regards,
MFelix
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
Re: Filter on year BEFORE selected year in slicer
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-21-2017 06:00 AM
That might do the trick! Thanks a lot for posting the link.