In a slicer, all userID is not showing. How to get all userID visible in slicer selection!

[sagarsahoo_123]

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

[ADPowerBI1]

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:

[sagarsahoo_123]

Hi @ADPowerBI1 , 

Please check the filter applied both Matrix table and Slicer. Both are having same filters.

Regards,

Sagar

[ADPowerBI1]

Hi, if you remake the slicer on another page with no filters applied (report level filters either) do the missing IDs show?

[sagarsahoo_123]

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..........

WorkTime_Test = var max_date=max(FY_Calendar[Date])

            Var PreviousDates =DATESINPERIOD('6M_Calendar'[Date],max_date,-12,Month)

            Var Result = calculate(VW_Nippon_Productivity[Avg WT],

                        REMOVEFILTERS('FY_Calendar'),

                        KEEPFILTERS(PreviousDates),

                        USERELATIONSHIP(FY_Calendar[Date],'6M_Calendar'[Date]))

            Return result

--------------------------------------------------

For example

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

[amitchandak]

@sagarsahoo_123 , check if there is a visual level filter.

Or the interaction is missing between some slicer and Matrix?

[sagarsahoo_123]

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

[sagarsahoo_123]

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..........

WorkTime_Test = var max_date=max(FY_Calendar[Date])

            Var PreviousDates =DATESINPERIOD('6M_Calendar'[Date],max_date,-12,Month)

            Var Result = calculate(VW_Nippon_Productivity[Avg WT],

                        REMOVEFILTERS('FY_Calendar'),

                        KEEPFILTERS(PreviousDates),

                        USERELATIONSHIP(FY_Calendar[Date],'6M_Calendar'[Date]))

            Return result

--------------------------------------------------

For example

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