The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
I have plotted a matrix table taking user as UserID (Unique ID). But when i amm trying to search in Slicer all userID is not showing. Some are missing from that list. For example in below i am attaching a image in which if you look at the slicer very few are showing while lots of SAP ID is missing . How to get all SAPID in slicer!
If you look at the above image, after 51328764, 51751998 is showing. While in between many are missing.
Regards,
Sagar
Hover over this button on the filter, the "funnel" button. It should show you all filters applied reguardless of filter context. Send a screenshot back and we'll have a look 🙂 If nothing shows, check there's no aggregation happening here:
Hi @ADPowerBI1 ,
Please check the filter applied both Matrix table and Slicer. Both are having same filters.
Regards,
Sagar
Hi, if you remake the slicer on another page with no filters applied (report level filters either) do the missing IDs show?
Hi @ADPowerBI1 ,
Here i am bringing both Slicer and Table into another page and both are showing same value.
Here i am displaying the last 12 months Work time value from the selected month in slicer. Is that impacting anyways!
My code for this is given below..........
In the above image if i will only select the Nov month in the slicer and Personal ID in table, both are giving same value, but when i have applied 12months Work time to display last 12 month work time, it is giving other Personal ID which are not showing in Slicer. For example in the above image 2nd row Personal ID is not there in Slicer but showing in the Matrix table.
Is there any ways to sync both Slicer and Matrix table! Your help is much appriciated !
Regards,
Sagar
@sagarsahoo_123 , check if there is a visual level filter.
Or the interaction is missing between some slicer and Matrix?
Hi @amitchandak ,
Thanks for your quick reply. I have checked the filter selection and everything looks fine but not sure if any other parameter needs to be checked. If you look at the below image the 2nd SAPID is not showing in the Filter itself when the filter is for ALL. Here 1010665 highlighted in yellow is missing from the filter as well from slicer when it is selected ALL but showing in the Matrix table.
Regards,
Sagar
Hi,
Here i am displaying the last 12 months Work time value from the selected month in slicer. Is that impacting anyways!
My code for this is given below..........
In the above image if i will only select the Nov month in the slicer and Personal ID in table, both are giving same value, but when i have applied 12months Work time to display last 12 month work time, it is giving other Personal ID which are not showing in Slicer. For example in the above image 2nd row Personal ID is not there in Slicer but showing in the Matrix table.
Is there any ways to sync both Slicer and Matrix table! Your help is much appriciated !
Regards,
Sagar
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |