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

 

 

 

 

 

 

 

 

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
    )

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community 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
    )