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.
I have a simple dashboard that essentially allows users to select a record from a table using a slicer, and which then populates a report based on that single row. This works fine, but I'd also like to include a scatter plot that shows where the selected record falls within the entire data set, but that's where I'm running into trouble; at the moment, selecting a record from the slicer then removes all others from the scatter chart, as expected, leaving me with a scatter of one!
Is there a way to either make my scatter chart ignore the slicer, so it always displays the entire dataset?
I've tried using the ALL function in DAX to create a column that ignores any filtering, but I think I'm probably using it wrong as it's not working and I get an error message about supplying a table where a single value is expected.
Also, while I'm asking for help, if there is a way to do the above, is there a way that I can set the chart to "call out" or highlight the value selected in the slicer, essentially pointing out where that record falls in the data?
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks; super obvious solution that I just wasn't aware of!
I don't suppose there's an option as easy as that to call out a specific dot/point within a chart, depending on a slicer?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |