Numeric range slicer

[BastiaanBrak]

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

[HotChilli]

What have you tried so far?  

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

[BastiaanBrak]

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?

[v-shex-msft · Accepted solution]

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

[BastiaanBrak]

Thanks Xiaoxin, I will try that.