Enable slicer to filter the measure at a "Month" level

[mdalton2100]

Using the slicer feature, I want the user to be able to filter the visual to only display the Month(s) when the total minutes summed for that month exceed the minimum measure ‘thresh-hold’ selected in the slicer itself. Right now, the slicer filters out measure values at the individual date level which do not exceed the ‘thresh-hold’. Maybe there is a better way to highlight such months, rather than trying to use the slicer, idk. Data model attached.

Data Model with Mockup _ filter measures by Month total.pbix (3.0 MB)

[BrianJ]

@mdalton2100 ,

I just posted a solution on a totally different question, where the approach I used might work well for you here also. That user also wanted to filter at the month level. I used two disconnected date tables to define a start and end month, and then harvesting those dates created a 0/1 dummy variable measure reflecting the logic of the records he wanted to show, and then put that measure in the filter pane and set it equal to 1. I think that approach would work well here, defining the dummy variable both in terms of the start and end dates, but also the minimum minute threshold.

Monthly Attrition Chart

@KieftyKids , If I understand the requirement correctly, I think the solution below should work for you: [image] Here’s how I did it: created two disconnected dates tables, one for the start date slicer and one for the end date slicer created the following [In Selected Range] measure to filter out any dates in the bar chart not within the range defined by the slicers: In Selected Range = IF( AND( MAX( Dates[MonthnYear] ) >= [Harvest Start Month], MAX( Dates[Mo…

See what you think. I hope this is helpful.

– Brian

[EnterpriseDNA]

Hi @mdalton2100, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

[mdalton2100]

Thank you for looking into my issue. The key issue with my problem is that the default Slicer tool impacts the sum totals by month when ‘activated’. Yet the user requires leveraging the slicer feature (dynamically) to display company IDs that exceed the slicer selected minute thresh-hold for a given month – without changing the minute totals themselves! Maybe this requires a different approach, not sure. I suppose I’m just not apprehending how your other solution could be applied here.
Data Model with Mockup _ filter measures by Month total.pbix (3.0 MB)

[Greg]

Hi @mdalton2100.

Give this a try:

• remove [Total Minutes_m] slicer
• add what-if parameter for [Total Minutes Threshold] and add slicer to page
• create new measure for [Total Minutes Above Threshold]
• change table value shown:
  • remove [Total Minutes_m] column
  • add [Total Minutes Above Threshold] measure

---

All Minutes Above Threshold =
IF(
    [All Minutes (sum)] >= 'Total Minutes Threshold'[Total Minutes Threshold Value],
    [All Minutes (sum)],
    BLANK()
)

---

Hope it helps.
Greg
eDNA Forum - Filter Measures by Month Total.pbix (3.0 MB)

[EnterpriseDNA]

Hi @mdalton2100, did the response provided by @Greg help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

[mdalton2100]

Greg … Thanks, the solution looks good. However, I’m having a bit of trouble re-producing your solution. So I added a 2nd report page in the same data model, where I attempted to re-produce your solution without success. Can you please check it out? Hopefully I made a simple mistake.

eDNA Forum - Filter Measures by Month Total - SOLVED.pbix (3.1 MB)

[Greg]

Hi @mdalton2100. You’re using a standard slicer on your new page, and SELECTEDVALUE returns blank when multiple values are available. Using a what-if parameter will allow SELECTEDVALUE to return a single value should provide the way forward.
Greg

[mdalton2100]

Hi Greg. I assumed that applying a What-If parameter for purposes of the visual would do the trick. It’s not clear to me how your solution enables the slicer to select one incremental value at a time. I’ve re-attached the .PBIX file: first report page is your solution, second one is my (failed) attempt at replicating it. - Marcus

eDNA Forum - Filter Measures by Month Total - SOLVED.pbix (3.1 MB)

[Greg]

Hi @mdalton2100. Use the [Modeling \ New parameter] menu item and fill-in the dialog, and ensure “Add slicer to this page” is checked.

Hope it helps.
Greg

[mdalton2100]

Thanks Greg! Works just fine now. Solved.