Skip to main content
cancel
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.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.