Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
71 | |
49 | |
45 | |
20 | |
17 |