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

Ignore Date Slicer for some tables

Hi

 

As a preface I'll admit I'm the absolute newest of the new to using PowerBI, I've had absolute basic experience and I'm encountering what I thought would be a very easy problem to solve but is proving quite annoying. I have a front sheet with a date slicer with week commencing dates attached to it, and underneath average feedback scores for the current year which change as you change the slicer dates. Works great except I also need some YTD score boxes beside the weekly ones, and of course these change whenever I change the date slicer mentioned above. So it sounds very simple to somehow make the YTD one ignore the rule of the slicer and include all dates, except I've tried about 5 different methods online and none of them are working, probably impeded by my limited knowledge of how to use Power BI. I've tried the format tab, and editing the interactions. That doesn't do anything. I've tried creating a whole new separate table of dates and tried linking it to that somehow but it didn't work, and honestly I didn't have a clue what I was doing. I've tried making some measures including ALL to ignore filters and that doesn't seem to work. The issue is probably really obvious to someone who knows, but I'm really stuck. 

 

Any help would be greatly appreciated

 

Cheers,

 

Phil

1 ACCEPTED SOLUTION

Accepted Solutions
RMDNA Senior Member
Senior Member

Re: Ignore Date Slicer for some tables

Hi @ylihp,

 

"Edit interactions" is the way to go, if your tables are properly connected. I'm assuming you clicked on the slicer and de-selected the table?

 

Could you post a pic of your relationship map (with any sensitive data blacked out)?

View solution in original post

3 REPLIES 3
RMDNA Senior Member
Senior Member

Re: Ignore Date Slicer for some tables

Hi @ylihp,

 

"Edit interactions" is the way to go, if your tables are properly connected. I'm assuming you clicked on the slicer and de-selected the table?

 

Could you post a pic of your relationship map (with any sensitive data blacked out)?

View solution in original post

Highlighted
ylihp Frequent Visitor
Frequent Visitor

Re: Ignore Date Slicer for some tables

IT WAS THAT SIMPLE! I was clicking on all of the tables and trying to block the interaction from them to the slicer and it wasn't working but when i click the slicer and block interactions from each of the YTD scores it works like a charm. Thanks so much for that. I knew it had to be a simple solution!

Chihiro Established Member
Established Member

Re: Ignore Date Slicer for some tables

For YTD you could create separate measure as well.

Using CALCULATE(SUM([ValueColumn]),ALL(TableName)) or combine it with FILTER(ALL(TableName), Expression) to ignore slicer filter context, and use custom filter.

 

Ex: Assuming you have Date column and have more than current year's data, without date dimension table...

=
CALCULATE (
    SUM ( TableName[ValueColumn] ),
    FILTER (
        ALL ( TableName ),
        YEAR ( TableName[DateColumn] )
            = YEAR ( TODAY () )
    )
)

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 332 members 3,586 guests
Please welcome our newest community members: