cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

I'm not sure I'm understanding what you did in that picture.

Let me give an example of one of my visuals.

I have a pie chart.

Legend is: ticket_source

Value is: %GT Count of ticket_id

What do I need to do to this chart to apply the slicer choice to it, so it only counts tickets of the correct age?

If it can't be done on as a page filter, I could apply it to each indivdually, that won't be a problem.

Super Contributor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

@AndrewP

In visual level filter put the measure created and select is not blank.

Share sample data and expected result.

Lima - Peru

Proud to be a Datanaut!

Regular Visitor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

I tried that.

In every visual exept for one line chart, no matter what's selected, the chart goes blank.

I'm not sure what i'm doing wrong.

http://i.imgur.com/XFNlUcm.png

The data I'm working with isn't quite something I can share, but I can describe it.

Source: the word email, web, phone, or other

ticket_id: index field for all tickets, sequential integer

TicketAge: a calculated colum for the difference in days between the creation date and TODAY()

Values-FilterSlicer: the example for the measure you gave me, changed to reference the custom table along with the TicketAge column.

Super Contributor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

@AndrewP

For sample this measure works in a chart where legend is Type of Ticket and Values are count of ticket id.

```CountRows-Filter =
CALCULATE (
COUNTROWS ( Table1 ),
Table1[TicketAge] <= VALUES ( RangeAge[Max] )
)```

Lima - Peru

Proud to be a Datanaut!

Regular Visitor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

Is there no way to universally do this for all visuals on a page?

Having a custom measure for each invidivual item seems horribly inefficient, where as with a raw SQL query I could generate exactly the results I'm looking for.

Super Contributor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

@AndrewP

The last measure works for several scenarios. Maybe in your report is not necessary create a measure-filter for each visual, depends of your context and data model.

Like i said in previous post for the moment (accord to my knowledge) use a measure in a page level filter.

Lima - Peru

Proud to be a Datanaut!

Regular Visitor

## Re: Is there any way to get a slicer where applied value is less than or equal to what's chosen?

I THINK I got it working

I used

```TA_Data =
IF (    HASONEVALUE(age_slicer_values[Range]),
CALCULATE(
COUNTROWS('dev ost_ticket'),
'dev ost_ticket'[TicketAge] <= values(age_slicer_values[Value])
),
COUNTROWS('dev ost_ticket')
)```

For the charts using counts and

```TA_Filter = IF (    HASONEVALUE(age_slicer_values[Range]) && HASONEVALUE('dev ost_ticket'[TicketAge]),
IF (
VALUES('dev ost_ticket'[TicketAge]) <= VALUES(age_slicer_values[VALUE]),
1,
0
),
1
)```

as a visual filter for those using Sums

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)