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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.