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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pep69saravia
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])
return
FILTER('Hours Worked','Hours Worked'[Week] = WeekSel)
If instead of a variable, I assign the value of the week, if that works for me,
Thanks

3 REPLIES 3
KNP
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 ;).
chrome-9xf-Zagzel-B

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.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
v-xiaotang
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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.