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 Clusted column chart as shown, but I wanted to be able to filter to only one y axis value at a time using a slicer selection. I cannot use a slicer because all three values on the chart are calculated measures. Is it possible to do this?
@Anonymous , You need to have what-if parameter and based on that you can filter
You can have a measure like this or you can use this in visual lebel filter
measure =
var _max = minx(allselected(whatif), whatif[value])
var _min = maxx(allselected(whatif), whatif[value])
return
sumx(filter(Summarize(Fact, fact[Axis Col], Fact[Legend Col]) , [Measure] >=_min && [Measure] <= _max) , [Measure])
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |