Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MichaelTrudeau
New Member

Slicers not displaying all strings when published

Some of the fields are diasapearing when I publish a report.  I have created a calculated column to identify a few key categories to be used in a slicer:

 

Help Desk = if('Combined SNOW'[category]="CalVAX-Clinic","Clinic",if('Combined SNOW'[category]="CalVAX-Skedulo","Clinic","Provider"))
 
It works fine in the desktop application, but breaks when I publish the report.  I don't have any other slicers selceted and Cross Filter Direction is set to 'Both' .  Specifically the 'Clinic' is gone from the published report. 
 
Desktop:
 DesktopDesktop
 
Published report: 
Published.PNG
 
3 REPLIES 3
v-xulin-mstf
Community Support
Community Support

Hi @MichaelTrudeau,

 

Please check If you have set any filter in power bi service.

You can try to refresh data and check.

You can also refer the solutions of  the related posts:

https://community.powerbi.com/t5/Service/Power-BI-Service-Data-Missing-after-refresh/m-p/626177

https://community.powerbi.com/t5/Service/Data-Missing-after-Service-refresh/m-p/1027128

 

Best Regards,

Link

Tahreem24
Super User
Super User

@MichaelTrudeau  that's weird. 

Can you just click on funnel like icon on the help desk slicer just like funnel icon next to Date Slicer as per your screen shot? 

So, that you can see what are the values are being selected in desktop verion and same for the published version. 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Just curious...do you have seperate dev, test and production environments?  We do and sometimes the data we pull in our dev environment isn't the same as the data pulled in the test or production environments.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.