topic Re: Creating an interval Slicer out of an calculated table in DAX Commands and Tips

Creating an interval Slicer out of an calculated table

Anonymous — Wed, 13 Mar 2024 15:20:00 GMT

Hi everyone,

I have this dax calculated table:

Y variables = {

("arpu_max", NAMEOF('customer'[arpu_max]), 0),

("arpu_mean", NAMEOF('customer'[arpu_mean]), 1),

("arpu_median", NAMEOF('customer'[arpu_median]), 2),

("arpu_min", NAMEOF('customer'[arpu_min]), 3),

("arpu_Q1", NAMEOF('customer'[arpu_Q1]), 4),

("arpu_Q3", NAMEOF('customer'[arpu_Q3]), 5),

("arpu_total", NAMEOF('customer'[arpu_total]), 6),

("client_id", NAMEOF('customer'[client_id]), 7),

("km_driven_max", NAMEOF('customer'[km_driven_max]), 8),

("km_driven_mean", NAMEOF('customer'[km_driven_mean]), 9),

("km_driven_median", NAMEOF('customer'[km_driven_median]), 10)

}

An the columns from that calculated table looks like this:

The calculated table I can put in in a Slicer like this:

but can I create a new slicer as an interval with the data from that specific column selected from the previous slicer?

Right now what I can do is having the calculated table in a scatter plot and activate the zoom slider, but I want the zoom slider to be as Slicer in order to be synced with other tabs in my report:

Re: Creating an interval Slicer out of an calculated table

lbendlin — Wed, 13 Mar 2024 21:29:42 GMT

An the columns from that calculated table looks like this:

No, that's already the next step. The columns from the calculated table look like this:

that's how Field Parameters work.

You can put Field Parameters on the Y axis, but not for a Scatter plot. They also sadly don't work on custom visuals like Deneb.

Re: Creating an interval Slicer out of an calculated table

Anonymous — Thu, 14 Mar 2024 07:27:52 GMT

Yes, they look like that with Field Parameters.

What I want is to filter by that Field Parameter, then filter by the interval in that Field Parameter, and use this filtration with SyncSlicer on another page. But I don't know how to put the values from that Field Paramenter in a slicer.

Re: Creating an interval Slicer out of an calculated table

lbendlin — Thu, 14 Mar 2024 17:10:43 GMT

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Re: Creating an interval Slicer out of an calculated table

Anonymous — Tue, 19 Mar 2024 07:24:18 GMT

This can be solved by creating the slicer with the field and then pressing "Show values of selected field".