Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have one table with 3 years of monthly sales that includes products numbers and an additional table with about 500 products numbers I want to pull sales totals for. How do I get it to filter on that table? I've added it as to 'Filters on this page only', all of the products numbers are selected, but my visual is still showing all records in the original file. I'm sure it's a simple thing to do, but being so new to Power bi, I was hoping someone could walk me through it.
Thanks!!!
Solved! Go to Solution.
Hi @Anonymous ,
You can add a filter in your formula :
'Table'[List Number] IN VALUES('Table2'[Nums Q4])
Best Regards,
Dedmon Dai
@Anonymous , is the product table(assumed have a unique product and used in slicer) is joined properly. If join is missing or inactive it can happen
If the interaction has been turned off this can happen
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
If all has been used in table formula it can happen
calculate([measure],all(Table))
@Anonymous share sample data and what you are trying to achieve, also share the screenshots. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
The link you provided is no longer valid. I only want the visual to show the product numbers that are the on Q4 Prod nums list that are included the 2017 file in the List Number field. 2017 would be my main file and Q4 Prod nums my secondary file. In essence a vlookup to determine the sales for certain product numbers during a partical year. Screenshots are attached.
@Anonymous Do you have a relationship between your two tables?
If not, you can also accomplish this using the IN operator.
Hi Greg!
I don't have a relationship set up between the two tables. How would I do that?
Thanks for helping the newbie!
_stephanie
Hi @Anonymous ,
You can add a filter in your formula :
'Table'[List Number] IN VALUES('Table2'[Nums Q4])
Best Regards,
Dedmon Dai
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |