cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wmorris20
Helper II
Helper II

Page Level Filter for Value Range

We have a report that displays a collection of visualizations and one of the measures is Year to Date Dollars.  The problem we face is that many of the measure values are near $0, which makes the visualization quite busy.  I'd like to be able to add a visualization to the report that essentially allows the user to filter out the outliers and focus in on the data that really matters.

 

I know this can be done using filter at visualization, page, and report level filtering.  However, I feel this is quite unituitive for the end user to have to click on the visualization, open the filter toolbar, and select the correct measure to filter.  Since I already know what they will likely want to filter, it would be excellent if I could present a filter that allows them to select a range of values.  I imagine I would need to turn off interactions to other visualizations, because context probably matters in this case.

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft
Microsoft

Hi @wmorris20

 

Have you tried the new Numeric Range Filter that was released in the March update?

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-slicer-numeric-range/

 

You will have to turn it on in your options and I don't think it is live in the service yet (won't be far away)


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Phil_Seamark
Microsoft
Microsoft

Hi @wmorris20

 

Have you tried the new Numeric Range Filter that was released in the March update?

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-slicer-numeric-range/

 

You will have to turn it on in your options and I don't think it is live in the service yet (won't be far away)


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thanks for pointing me in the right direction.  The update says that it doesn't yet work with Measures, but that functionality is on the way.

 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-feature-summary/

Hi @wmorris20

 

While it won't work on measures, if you drop a field onto it that covers the number range you want it might work?

 

eg, what field do you use on the axis of your visual?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

That's a good idea.  Although it technically works, it doesn't work in a practical sense.  In this case, we would need to filter Sales Dollars which is then aggregated to YTD Dollars, which is want we want to display.  The problem with filtering Sales Dollars is that one segment might have 1 record of $10 but another segment might have 200,000 records of $10.  Filtering it above $10 will significantly limit the use of displaying the YTD.

 

If we filter at the Measure level, we can achieve removing the noise.

Some other ideas (although again, not ideal) are

 

  • hard code the start/finish axis to fixed values
  • use a Log scale to pull back the outliers.

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.