Create Axis values as slicer

[Vinesh_1]

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) and this causes all the smaller values dumped together .

So I'm trying to create a solution by using sllicer with X-Axis buckets where user can select buckets 0-50, 50-100, 100+.  

My Table is App_1 table with columns AppealID,Providername,Paid Amount.

I looked few similar posts and I haev created new table(X_Dim) with column 1 which has buckets but was not sure how to link X_Dim to main table.

Please advise 

 

[v-chuncz-msft · Accepted solution]

@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
    )