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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Filter Table

Good morning, my problem is the following, I have a selector by week, which correctly returns the value of the week number in a card, "Filter = SELECTEDVALUE(Calendar[Week])", I also get the value of the first day of that week, Monday = FIRSTDATE('Hours Worked'[Date])
Up to here okay.
Now I want to represent the data of that week or that day, creating a table with the FILTER function
HoursSelect = Var WeekSel = SELECTEDVALUE(Calendar[Week])
FILTER('Hours Worked','Hours Worked'[Week] = WeekSel)
If instead of a variable, I assign the value of the week, if that works for me,

Super User
Super User

I'm confused as to why you need to go about it this way. Maybe some more detail would help.

Can you include a screenshot of your data model showing the relationships?

Some dummy data, pasted as data would be helpful.

Also, what is your desired outcome, what is not working currently? 


Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Community Support
Community Support

Hi @Pep69saravia 

>>  creating a table with the FILTER function

that is not possible to create a table with the value selected in slicer dynamically. But if you want to dynamically create a virtual table, it is feasible, but you still need to perform some aggregation operations on it to display the value in visual.


Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

How should I do it? What do you advise me, because i'm lost, Thanks

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.