cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vinesh_1 Visitor
Visitor

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 

 

 

 

 

Scatter.PNG 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create Axis values as slicer

@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
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Create Axis values as slicer

@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
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.