Forum Discussion

Ashish9201's avatar
Ashish9201
Icon for Helper I rankHelper I
4 years ago

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

  • 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]
    RETURN
        SWITCH (
            TRUE (),
            CurrentStatus IN CurrentSelection, 1,
            "All" IN CurrentSelection, 1,
            0
        )
     
    Thanking you in advance 🙂 
  • 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