cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BastiaanBrak Regular Visitor
Regular Visitor

Numeric range slicer

hi all, first time poster here. I am recreating some Tableau workbooks / dashboards in Power BI and have a particular question on the numeric range slicer which I have built in one of my Tableau dashboards. Based on my reading of the relevant Power BI product page on this functionality and some preliminary testing it seems I can't (currently) replicate the numeric range slicer as implemented in the 'Rainfall map' tab of the Tableau workbook here (see  https://cereals.ahdb.org.uk/monitoring/weatherhub.aspx).

 

Is that correct or am I missing something?

Many thanks, Bastiaan

 

TableauNumericRangeSlicer.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Numeric range slicer

HI @BastiaanBrak,

 

You can try to add a calculated column to calculate and store summarize value, then use this as source of slicer.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
4 REPLIES 4
HotChilli Established Member
Established Member

Re: Numeric range slicer

What have you tried so far?  

 

Have you seen this page https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range

BastiaanBrak Regular Visitor
Regular Visitor

Re: Numeric range slicer

Yes, I referred to that in my post ("Based on my reading of the relevant Power BI product page on this functionality").

The first point under 'Limitations and considerations', i.e. [The numeric range slicer currently filters every underlying row in the data, not any aggregated value.] suggests that the current functionality of the numeric range filter in Power BI enables filtering out the row-values (in my case daily rainfall totals) but not the aggregated values (rainfall totals over longer period). I have tested this in my workbook and this is indeed what happens. 

Any idea how I could filter on the aggregate values instead?


Community Support Team
Community Support Team

Re: Numeric range slicer

HI @BastiaanBrak,

 

You can try to add a calculated column to calculate and store summarize value, then use this as source of slicer.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
BastiaanBrak Regular Visitor
Regular Visitor

Re: Numeric range slicer

Thanks Xiaoxin, I will try that.