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 everyone,
I have a scatter chart which shows median lines to divide the results up into four quadrants (the median lines are at approx. 3.9 on the performance axis and 2.7 on the importance axis):
In addition to this I also have a slicer that then only selects certain groups of data points based on topic. The problem is that when I apply the slicer it then moves the median lines relative to the newly selected data (now at approx. 4.05 on the performance axis and 2.65 on the importance axis):
Is there a way to setup the graph so that the sliced results still show up using the original median lines from the unsliced graph?
Thanks in advance for your help!
Hi @Anonymous ,
I can't reproduce your scenario. When I filter on slicer, median line will dynamic changes based on selection. Can you please share some sample data for test?
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for having a look. I was also getting the same results - I'm trying to get it to not change the median line after slicing. I basically want the sliced results to be judged based on the medians of the full data set, not a set of newly calculated medians that only relate to the sliced data.
Hope this makes sense!
Hi @Anonymous ,
So you means you want median line not effected by slicer/filters, right? If this is a case, you can write a measure formula with all function to ignore current filters, then use this measure as median line, it should not affected by slicers.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Regards,
Xiaoxin Sheng
Xiaoxin,
I am having the same problem. I have a measure that defines the x axis for a scatter plot. I am using the all() function in my measure to keep one of the slicers from affecting the value. The median lines still move. I believe my measure is correct as the x axis value for my scatter plots are not moving. Only the median line moves.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |