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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors