Undefined

[Anonymous]

I have a date_key column in the format( 20230704, 20230711,... 2023-year, 07-month, 04,11-days) & data type is whole number. I created a month column based on this DAX below

Month =

VAR YearPart = DIVIDE(INT('agg_route_trip'[date_key] / 10000), 1)

VAR MonthPart = DIVIDE(INT(MOD('agg_route_trip'[date_key], 10000) / 100), 1)

RETURN

    SWITCH (

        MonthPart,

        1, "January",

        2, "February",

        3, "March",

        4, "April",

        5, "May",

        6, "June",

        7, "July",

        8, "August",

        9, "September",

        10, "October",

        11, "November",

        12, "December",

        "Unknown"

    )

In my scatter plot I used count of distinct date_key as a field in Y-axis. In X-axis I have another field service avg EPK & service in values. I want to create 2 slicers for both X & Y axes. Based on these values I want to filter the scatter plot data.

1.  In my slicer for Y-axis I want as a numerical range. Ex 1 to 31 slicer range but I am getting 20230701 to 20230731(Selected july month in the month slicer)
2. In Y-axis slicer if I select a range of 1 to 20 then in the scatter plot services b/w 1 to 20 should come. But the service value is not responding to this filter properly. It is giving the original value only(Lets say in july month no of services are 135. I selected a range of 1 to 20 then no of services should be less than 135 but it is showing 135 only)
3. Exact requirement is using X-axis slicer & Y-axis slicer both I want to filter the data. But I am facing the above problem

Someone please help me with this

[Anonymous]

From the scatter plot above I want the values 37.26(blue line) & less than 33(red line) which are in the first grid. For this I want to create 2 slicers X-axis & Y-axis slicer. Based on these 2 values I want to filter that data

https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing