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.
Good Afternoon,
I have numberous data tables from various suppliers with lots of different information, one of these is DocumentID.
Now my ain is to have a card counting all the document ID's from all the suppliers. Then I would like to have a slicer where I select the supplier and the car shows the count of DocumentID from that supplier selected in the slicer.
(At the moment I have four suppliers, each with thier own tables, but the common column of DocumentID).
Any suggestions here? Many thanks in advance.
Solved! Go to Solution.
I would suggest using Power Query. What you can do is create a custom column for each of those 4 tables where the custom column will simply be the name of that client (ClientName).
You can then create a fifth query where you append all those 4 tables into one and only keep the following two columns:
Hope this helps!
@MarkCalvert1988 the best approach would be to append the table together in power query and then you can get total count of document and able to slicer it by supplier as well, basically it will be one giant table (append of all 4 tables from various suppliers)
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.
@MarkCalvert1988 the best approach would be to append the table together in power query and then you can get total count of document and able to slicer it by supplier as well, basically it will be one giant table (append of all 4 tables from various suppliers)
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.
Thanks, a powerquery was just the ticket, appended them together and now works like a dream!
I would suggest using Power Query. What you can do is create a custom column for each of those 4 tables where the custom column will simply be the name of that client (ClientName).
You can then create a fifth query where you append all those 4 tables into one and only keep the following two columns:
Hope this helps!
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |