Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good day All.
Just wondering if someone can help me my issue.
I have created a measure that grabs the selected week in the "Filters on this Page" and put it in dim date table.
Now I created a Table using Summarizecolumns and would like to filter this using the value above but its seems it is loosing the context. Created a variable and assigned the selected week measure and include it in the table just to see the value. As my selected week measure grabs the max week (i.e 202226), when it comes to the table, it is now grabbing the max week which is wrong.
Any idea how to go about this?
Solved! Go to Solution.
@LeoS , a calculated table can not take dynamic slicer/filter values
refer if needed
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
@LeoS , a calculated table can not take dynamic slicer/filter values
refer if needed
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Thank you. That makes sense.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |