Filtering Gauge based on slicers created through measures

[Ashish9201]

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

[Ashish9201]

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

[Ashish9201]

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 🙂 

[danextian]

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...