• 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

Can you make value filters dynamic, based on slicer choice?|Dashboards & Charts|Excel Forum|My Online Training Hub

You are here: Home / Can you make value filters dynamic, based on slicer choice?|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 & ChartsCan you make value filters dynamic,…
sp_PrintTopic sp_TopicIcon
Can you make value filters dynamic, based on slicer choice?
Avatar
Belinda Baker

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 23, 2022
sp_UserOfflineSmall Offline
1
August 23, 2022 - 3:49 pm
sp_Permalink sp_Print

Hi Everyone,

I've been watching Mynda's videos and for years and only just found this forum! In desperation I've decided to post this question.

I have a dashboard with three pivot charts and I have applied a value filter 'equal to or greater' to limit the results for readability. The charts show training courses required for staff across the organisation, and I've included value filters so that courses are shown only where there is a minimum number met.

I have a slicer which you can then filter the courses based on the organisations 6 branches. The issue I have, is that once you start filtering based on the branches, the value filter is still applied and many of the branches have courses less than the 'equal to or greater' filter.  So there is no data to show.

Is it possible to make a value filter dynamic based on using the slicer? Can this be done with a formula? Essentially I only want the value filter to show when slicer filtering is not applied but to be turned off once slicer filtering is applied.

Thanks in advance

Belinda

Avatar
Jessica Stewart
Northern USA
Member
Members


Trusted Members
Level 0
Forum Posts: 204
Member Since:
February 13, 2021
sp_UserOfflineSmall Offline
2
August 24, 2022 - 12:06 am
sp_Permalink sp_Print

I wonder if you could write a DAX measure that would take into account the filtering when needed and use that in a Power Pivot? I'm not sure if that is possible, other than that possible solution I think you would need VBA.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4449
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
3
August 24, 2022 - 7:53 pm
sp_Permalink sp_Print

Hi Belinda,

Please see this tutorial on switching measures based on slicer selection.

Mynda

Avatar
Belinda Baker

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 23, 2022
sp_UserOfflineSmall Offline
4
August 29, 2022 - 9:42 am
sp_Permalink sp_Print

Hi Mynda,

Thanks very much. I think your suggestion would work in the instance of the data I'm using.

I would need to add the measures I want to see for each branch, which is a COUNT of a particular column (training courses) and then table I create for aggregations would be the name of the branches. That's how I understood it anyway!

I'll give it a go.

thanks,

Belinda

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4449
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
5
August 29, 2022 - 3:57 pm
sp_Permalink sp_Print

Hmmm, if you have a separate column for each course name then your data is not in the correct tabular layout for Power Pivot/PivotTables. Maybe that's why you're having trouble.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Richard West, Wesley Burchnall, Emma Klonowski, Kelly smith
Guest(s) 8
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
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27291

 

Member Stats:
Guest Posters: 49
Members: 31913
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.