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, I'm wondering if there would be a way to make only certain slicers affect a measure, I can't solve this by editing interactions because what I want to do is to have two separate filter slicers each one affecting a measure that codewise is the same, and I want to do this because this would allow me to compare the data from two periods of time and put it in a graph, for example, if I select one month with a slicer and then another one with the other slicer i then want to be able to present the data of each day of the two separate months in the same graph so that we can see if for example the total sales have increased every weekend, or if there has been a global increase in sales...
Solved! Go to Solution.
@antalgu So yes, you would use ALL, ALLEXCEPT, REMOVEFILTERS or KEEPFILTERS in your measure.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
@antalgu So yes, you would use ALL, ALLEXCEPT, REMOVEFILTERS or KEEPFILTERS in your measure.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, 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
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Thanks for the fast answer, that's all I needed to know, both ALL and ALLEXCEPT are quite useful for what I was describing, I didn't quite understand why they where useful the first time I read their definition, but after a little bit of research that was what I needed!
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 |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
76 | |
58 | |
47 | |
17 | |
12 |