Log In
Register
Home
New Member
August 23, 2022
Offline
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
Trusted Members
February 13, 2021
Offline
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.
New Member
August 23, 2022
Offline
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
July 16, 2010
Offline
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.
