Using slicer to show positive/negative development from measure

[Katalo]

Hello!

I have a measure comparing the sales for this month with the sales for the same month last year. I have multiple locations and make a comparison for each to see how much (in percent) sales have increased or decreased. I would like to use a slicer to filter out a specific range of increase/decrease. For example, I would only like to show stores wich have an increase between 5%-10%.

The problem as I see it is that I cant get the value range from the measure inside the slicer because I need to split up the values by store for the measure to work. I have tried using a calculated table to extract the measure values, but that wont work with my date slicer.

Anyone have a good idea how to tackle this?

[v-danhe-msft]

Hi @Katalo,

Could you please share some sample file to have a test and post your desired result if possible?

Regards,

Daniel He

[Greg_Deckler]

Should be able to use the disconnected table trick for this as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

But, very difficult to be specific without sample/example data and expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490