cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewP Regular Visitor
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.

Vvelarde Super Contributor
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.

 

To a better and faster way to help you:

 

Share sample data and expected result.

 

 

 

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AndrewP Regular Visitor
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.

Vvelarde Super Contributor
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
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AndrewP Regular Visitor
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.

 

Vvelarde Super Contributor
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
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




AndrewP Regular Visitor
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

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

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

Difinity Conference

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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)