Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hellou, can you please somebody help me?
I have pivot table like this and slicer with week.
Week | value |
1 | 10 |
2 | 20 |
3 | 30 |
4 | 40 |
5 | 50 |
6 | 60 |
7 | 70 |
8 | 80 |
9 | 90 |
10 | 100 |
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 😕
Solved! Go to Solution.
@Fiala This is pretty much the exact scenario for The Complex Selector: The Complex Selector - Microsoft Power BI Community
@Fiala This is pretty much the exact scenario for The Complex Selector: The Complex Selector - Microsoft Power BI Community