Forum Discussion
Ashish9201
Helper I
4 years agoFiltering Gauge based on slicers created through measures
Hi All, 1) I have created a Slicer through measures. 2) And a Gauge chart to represent the data. While i try to filter my slicer that was created through measures, the gauge chart doesnt res...
Ashish9201
Helper I
4 years agoHi danextian ,
Not sure if you can access the data since it is on dataverse platform.
However sharing you snap of the report that i have build. Slicers highlighted are created through the measures that i have created. The gauges are not following the filters applied on these slicers.
Formula used for measure creation:
ARPE Tiers Filter =
VAR CurrentSelection =
VALUES ( 'ARPE Tiers'[ARPE Tiers] )
VAR CurrentStatus = msdyn_timeentry[ARPE Tiers]
RETURN
SWITCH (
TRUE (),
CurrentStatus IN CurrentSelection, 1,
"All" IN CurrentSelection, 1,
0
)
Thanking you in advance 🙂