In the scatter plot I used count of distinct date_key/count of distinct date(On Y-axis) which will give No of days service operated.
So now in the Y -axis I have a numerice range. In x-axis I want to put service average EPK. In the values service. Now I want to create a slicer for this
in my dashboard(numerical range) & also for service average EPK(X-axis).
This is my Requirement:
On selection of particular month in month slicer, the scatter plot with percentile lines will change dynamically.In the 16 grids
If I want particular grid values(services) I want to use these 2 slicers & based on the selection of these 2 slicers I want to
filter the required grid data.
Someone please get me through this. I have attached pbix file below
https://drive.google.com/file/d/1ZRU9Ro45H9zcqWwoDVhjbQKtk6oVLtAz/view?usp=sharing
