Forum Discussion
Advocate IIPublished report slicer not working correctly
Hello,
I've encountered a weird problem. I have a report that is working correctly in Power Bi desktop but not in the Service. The report has a date slicer and two other slicers. Date slicer and one of the other two are working but one slicer is not when selecting values from slicer. It is working only when "select all" or none are selected.
- Data is same in the service, relationships are same in the service, interactions for slicers are correctly.
- Resetting filters or refreshing visuals does not help and same filters are in use both cases.
- Tried saving report with other name in PBI Desktop and published it to same workspace, no help.
- Updated PBI Desktop to the latest version.
- Slicer is not working in workspace or in app.
If I download pbix from the service and open it in PBI Desktop -> slicer is working...
Slicer worked ok in the service 5 days ago and I have not updated reports recently. I have not noticed same behaviour in other reports.
Any ideas?
12 Replies
v-saisrao-msftCommunity Support
HI Testeri,
Check whether Persistent filters are contributing to the unexpected slicer behaviour. Microsoft documents that saved filter selections, particularly when combined with bookmarks, can cause unexpected results. Reset the report to its default state and temporarily disable Persistent filters to check whether the behaviour changes. Also, compare the slicer's filtering behaviour with the Filters pane and verify the slicer selection and interaction settings.
Troubleshoot Visualizations in Power BI - Power BI | Microsoft Learn
Change settings for Power BI reports - Power BI | Microsoft Learn
Format filters in Power BI reports - Power BI | Microsoft Learn
Thank you.
TesteriHi v-saisrao-msft ,
I tried to reset report to default state and also checked persistent filters option in settings in desktop and in service, no help.
I created a new report page with brand new slicer and a card where selected slicer value is shown with a measure:
Debug selected =
SELECTEDVALUE(
'Table'[Slicer column],
"NOT SINGLE"
)
The card is showing correct value in desktop for every selection but not in the service. However, I noticed something more strange in the service. Card is showing correct value in service for ONE specific selection in slicer but all other selections are shown as "NOT SINGLE". 🤯
- v-saisrao-msft
HI Testeri,
The SELECTEDVALUE() function returns the selected value only when the specified column has exactly one distinct value in the current filter context; otherwise, it returns the alternate result. Please verify that the slicer is configured to filter the debug card using Edit interactions and check whether any synchronized slicers are affecting the selection. You can also use COUNTROWS(VALUES('Table'[Slicer column])) as an additional diagnostic to inspect the number of distinct values in the current filter context. These checks may help narrow down the issue
SELECTEDVALUE function - DAX | Microsoft Learn
Overview of slicers in Power BI - Power BI | Microsoft Learn
Change How Visuals Interact in a Report - Power BI | Microsoft LearnThank you.
- binitafulpagare
Kudo Commander
Hi Testeri,
Since the slicer works correctly in Power BI Desktop, including when you download the PBIX file from the Service, this may be related to a Power BI Service-specific issue rather than the report configuration itself.
I would suggest checking a few additional things:
1. **Browser testing:** Open the report in an InPrivate/Incognito window or try a different browser to rule out cached data or browser-related issues.
2. **Persistent filters:** Check whether persistent filters or saved personal bookmarks are affecting the slicer's behavior.
3. **RLS validation:** If Row-Level Security is enabled, test the report using different user roles and compare the results.
4. **Slicer field:** Check whether the affected slicer uses a calculated column, a related-table column, or a field with duplicate values.
5. **Service health:** Since the issue started recently without report changes, check the Microsoft Fabric/Power BI Service health status for any related incidents.
If none of these checks resolves the issue, I would recommend capturing the affected visual's details and submitting a support request to Microsoft, as it could be a Service-side regression.
One question: Is the affected slicer based on a column from the same table as the working slicer, or does it come from a related table in the semantic model?
That detail could help narrow down the root cause.
Thanks!
- Testeri
Hi v-saisrao-msft and binitafulpagare ,
v-saisrao-msft I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week?
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Images:
- Testeri
Hi v-saisrao-msft and binitafulpagare ,
v-saisrao-msft I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week?
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Hi v-saisrao-msft and binitafulpagare ,
I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card in service, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week?
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Hi v-saisrao-msft and binitafulpagare
I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card in service, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week.
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Hi v-saisrao-msft and binitafulpagare
I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card in service, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week.
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Hi v-saisrao-msft and binitafulpagare
I attached two images to compare situation in desktop and in service. Noticed that when hovering over filter in each card in service, it is filtering by selected value in slicer but it is not showing in the cards.
- Tried InPrivate and Incognito in different browsers. Same behaviour.
- I have tried checking persistent filters setting in options (Don't allow end user to save filters...) and published report. Same behaviour.
- There are no security roles added for report.
- It is a custom column combined from two columns in the same table. Slicer field has no duplicate values BUT there are a few empty (BLANK) values. I tested by changing slicer column to other same table column that has a value in every row and created additional debug measures for that column -> CARDS ARE SHOWING SELECTION CORRECTLY. So the custom columns in slicers are working differently in the service now compared to last week.
I changed the custom column code and looks like it is now working correctly in the slicer. Quite a strange problem.
THANK YOU VERY MUCH!
- Testeri
Sorry for spamming. I Got "NOT ACCEPTED" error when tried to send messages and did not see them after page refresh. Now they are all there....
