Forum Discussion
Filtering 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 respond to the selection.
While i make changes in other filter apart from the measure one, the data is represented correctly in the gauge chart.
Can someone please help me on this?
Regards,
Ashish Gupta
3 Replies
- danextian
Super User
Hi Ashish9201 ,
What do you mean by a slicer created from a mesure? Please provide a sanitized sample pbix.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message - Ashish9201
Helper I
Hi 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]RETURNSWITCH (TRUE (),CurrentStatus IN CurrentSelection, 1,"All" IN CurrentSelection, 1,0)Thanking you in advance 🙂 - Ashish9201
Helper I
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 respond to the selection.
While i make changes in other filter apart from the measure one, the data is represented correctly in the gauge chart.
Can someone please help me on this?
Regards,
Ashish Gupta