Forum Discussion
Using slicer to show positive/negative development from measure
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?
2 Replies
- Greg_Deckler
Community Champion
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/ba-p/279563
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
v-danhe-msftMicrosoft Employee
Hi Katalo,
Could you please share some sample file to have a test and post your desired result if possible?
Regards,
Daniel He
