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.
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?
Hi @Katalo,
Could you please share some sample file to have a test and post your desired result if possible?
Regards,
Daniel He
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
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |