Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
What have you tried so far?
Have you seen this page https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range
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?
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
Thanks Xiaoxin, I will try that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |