Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
adrianPadurariu
Resolver I
Resolver I

Creating an interval Slicer out of an calculated table

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:
adrianPadurariu_0-1710342848225.png

 

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

adrianPadurariu_1-1710342938999.png

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:

adrianPadurariu_2-1710343175069.png

 

 
1 ACCEPTED SOLUTION
adrianPadurariu
Resolver I
Resolver I

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

 

View solution in original post

4 REPLIES 4
adrianPadurariu
Resolver I
Resolver I

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

 

lbendlin
Super User
Super User

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:

lbendlin_0-1710365317565.png

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.

 

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.

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.