Forum Discussion

Vinesh_1's avatar
Vinesh_1
Regular Visitor
7 years ago
Solved

Create Axis values as slicer

Hi All,   I have a scatter plot with Count(Appeals) on X- Axis and Charge Amount on Y- Axis.  My issue is - In the graph below ,you see the right top circle is the highest (farthest from all other...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Vinesh_1,

     

    Drag measure below to Visual level filters and set Show items when the value is 1.

    Measure =
VAR c =
    COUNT ( App_1[AppealID] )
RETURN
    IF (
        c > SELECTEDVALUE ( X_Dim[MinV] )
            && (
                ISBLANK ( SELECTEDVALUE ( X_Dim[MaxV] ) )
                    || c <= SELECTEDVALUE ( X_Dim[MaxV] )
            ),
        1
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Vinesh_1,

 

Drag measure below to Visual level filters and set Show items when the value is 1.

Measure =
VAR c =
    COUNT ( App_1[AppealID] )
RETURN
    IF (
        c > SELECTEDVALUE ( X_Dim[MinV] )
            && (
                ISBLANK ( SELECTEDVALUE ( X_Dim[MaxV] ) )
                    || c <= SELECTEDVALUE ( X_Dim[MaxV] )
            ),
        1
    )