• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Slicers filtering giving blank charts|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Slicers filtering giving blank charts|Dashboards & Charts|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumDashboards & ChartsSlicers filtering giving blank char…
sp_PrintTopic sp_TopicIcon
Slicers filtering giving blank charts
Avatar
Ashley Paech

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
February 13, 2023
sp_UserOfflineSmall Offline
1
February 18, 2023 - 2:48 pm
sp_Permalink sp_Print

Sorry, Its hard to explain the problem properly in a few word for the title also I have a couple problems but I will start with the main one.

Ive got a dashboard showing sales and profit over the different categories and different locations and all seems to filter properly until I go to change months or locations where there is no matching data and the slicer doesnt know what to do and shows nothing and all my charts go blank. If you look at the pics, Dashboard1, everything is unfiltered and showing as it should. In Dashboard 2 Ive chosen January 2023 and weekending 2/1/2023 and everything has filtered as it should. In Dashboard 3 I choose February 2023 and the weekending slicer doesnt know what to show, finds no data and all my charts go blank until I choose a week in February and it comes good. The same thing happens when filtering the Categories and Sub Categories, if I choose beer item then go back to food it doesnt find what its looking for and my TOP 10 chart goes blank. What I need is for the slicers to have a default state where if I choose January it shows all the weeks in January, If I choose Beer it shows all the beer sub categories and if it cant do this what is your best suggestion around this.

Ok problem 2 and this relates back to the first 1 I had a year slicer and a month slicer to start with and I was having the above problem and watched a video of yours showing a slicer combining the year and month and thought that might help, it didnt, but I set it up in my data as "2023/01" but when its come into the slicer it show the day as well "01/01/2023". I tried changing it in the data model to I format I liked but it never passed through to the slicer, any ideas.

Problem 3 This dashboard is for a person of limited computer skills but I think he can handle it but there is alot of slicers to filter and was wondering if it is possible to make a clear filter button on the dashboard to make it easy to clear the slate. I know people will say you can use this shortcut or you just go into the ribbon and push this but I want this to look clean without the ribbon and be as simple as possible. Also any design suggestions you may have to the layout would be helpful as I just find it very cluttered and a bit overwhelming, Ive focused on getting it working more than design at this stage.

Any help with any of these would be wonderful hope I havent asked for too much and the first problem is the main one I need help with

Avatar
Ashley Paech

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
February 13, 2023
sp_UserOfflineSmall Offline
2
February 18, 2023 - 2:54 pm
sp_Permalink sp_Print

Sorry I forgot to add the picturesDashboard-1.jpgImage Enlarger

Dashboard-2.jpgImage Enlarger
Dashboard-3.jpgImage Enlarger

sp_PlupAttachments Attachments
  • sp_PlupImage Dashboard-1.jpg (66 KB)
  • sp_PlupImage Dashboard-2.jpg (65 KB)
  • sp_PlupImage Dashboard-3.jpg (41 KB)
Avatar
Ashley Paech

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
February 13, 2023
sp_UserOfflineSmall Offline
3
February 18, 2023 - 2:57 pm
sp_Permalink sp_Print

Also not sure If my workbook uploaded as it gave an error so here it is with a couple sheets of data

Also Microsoft 365

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4449
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
February 19, 2023 - 10:12 am
sp_Permalink sp_Print sp_EditHistory

Hi Ashley,

The behaviour described in issues 1 and 2 is not something you can change. The best you can do is educate the user. You could use the technique I use to force people to select a single item in the slicer, as explained here: Force Excel Slicers to Single Select

This puts a notice in the chart title alerting them to the issue and how to resolve it. I'm sure once they use the report a couple of times they'll realise what to do.

As for clearing filters, you would need to record a macro that does this and assign it to a button.

I hope that points you in the right direction. If you get stuck with the macro, please post a question in our VBA forum.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Dario Serrati, Valentyn Kristioglo, Nada Perovic, Andrew Er
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27279

 

Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.