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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Fiala
Helper II
Helper II

display week base on week slicer

Hellou, can you please somebody help me?

 

I have pivot table like this and slicer with week.

Weekvalue
110
220
330
440
550
660
770
880
990
10100

 

If I select the tenth week, I want to see in the table only the values ​​up to the tenth week. If I select the fourth week, I only want to see the values ​​until the fourth week.

 

I create a measure like this: 

=Weekslicer = IF(HASONEVALUE('Calendar'[week]);VALUES('Calendar'[week]))

 

.. and measure: 

=var selectedweek= [Week slicer]

var currentweek=CALCULATE(max('Calendar'[week]);ALLEXCEPT('Calendar';'Calendar'[week]))

return

IF(currentweek<=selectedweek;sum(table;[vlaue]);BLANK())

 

Slicer still always filters only 1 selected week 😕

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Fiala This is pretty much the exact scenario for The Complex Selector: The Complex Selector - Microsoft Power BI Community



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@Fiala This is pretty much the exact scenario for The Complex Selector: The Complex Selector - Microsoft Power BI Community



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!