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

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!

Highlighted
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors