Numeric range slicer from measure

Question

Hi all&nbsp;Does anyone know how to do this with a measure (or a disconnected table with all values of 0-100 in)?&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-slicer-numeric-range&nbsp;Thanks!

alb · Answer

Hi Anonymous&nbsp;It is explained on the link you provide. What is it exactly that you do not understand or is not working?

anonymous · Answer

Hi&nbsp;AlB&nbsp;Well it says this CANNOT be done with a measure as the slicer. So is there a way TO do it, like with a disconnected table, or perhaps a summerized table?&nbsp;Thanks

v-lili6-msft · Answer

hi,&nbsp;Anonymous
Measure can't be drag into a slicer in power bi, measure&nbsp;itself is&nbsp;dynamic, This will lead to a circular dependency.
and you could create a relationship between&nbsp;the summarized table with basic table, then you could drag the field in&nbsp;the summarized table into a slicer, and it will affect the basic table too.
&nbsp;
Best Regards,
Lin

anonymous · Answer

Hi&nbsp;v-lili6-msft&nbsp;Can you please give a simple example (or link to one) where you "could&nbsp;create a relationship between&nbsp;the summarized table with basic table, then you could drag the field in&nbsp;the summarized table into a slicer, and it will affect the basic table too."&nbsp;Thanks

v-lili6-msft · Answer

hi,&nbsp;Anonymous
A simple example:
this is basic data table and this is a summarized Table
basic Tablesummarized Table
then create a relationship between them like this&nbsp;

&nbsp;
Now you could use Column in&nbsp;summarized Table in slicer to filter the data in the basic table.
&nbsp;
Best Regards,
Lin
&nbsp;
&nbsp;

Forum Discussion

Numeric range slicer from measure

9 Replies

Related content

numeric range slicer

Issue with Input Slicer and Numeric fields in Power BI Service

Slicer on measures

numeric slicer for aggregated Y axis

Add Measures to Slicer