Forum Discussion
Current Selection Display
Hi DuncanYeah - DirectQuery limitations mean that creating new tables dynamically is not feasible, but you can still use ALLSELECTED to capture slicer selections that might go beyond existing data values.Pre-aggregating your data into manageable ranges or buckets could provide a performance boost and make querying over large value ranges more efficient.
Using dynamic slicer filters or ranges could help limit the selection scope while keeping the solution flexible.You can use the following logic to display the range the user selected via the slicer, without filtering the actual data:
concatenatex_cpe =
VAR mi = FORMAT(MINX(ALLSELECTED('table'[Money]), 'table'[Money]), "#0.0")
VAR ma = FORMAT(MAXX(ALLSELECTED('table'[Money]), 'table'[Money]), "#0.0")
RETURN
IF(
NOT ISFILTERED('table'[Money]),
"",
"[Money ($M)]: From " & UNICHAR(10) & mi & UNICHAR(10) & " to " & UNICHAR(10) & ma & " ; " & UNICHAR(10)
)you can consider using a relative filter or range slicer based on aggregation. This can ensure the user can filter within practical ranges without loading too many rows or overburdening the system. You could implement a dynamic range selection by creating bins or intervals at the database level, which Power BI can then handle more efficiently in DirectQuery mode.
Hope this works and helps in your scenerio
modified measure:
concatenatex_cpe =
VAR mi = FORMAT(MIN('table'[Money]), "#0.0") // Minimum value selected in the slicer
VAR ma =
IF(
ISFILTERED('table'[Money]),
FORMAT(MAX('table'[Money]), "#0.0"),
"78" // Set this to your desired max range, e.g., 78
)
RETURN
IF(
NOT ISFILTERED('table'[Money]),
"",
"[Money ($M)]: From" & UNICHAR(10) &
mi & UNICHAR(10) &
"to" & UNICHAR(10) &
ma & " ; " & UNICHAR(10) & ""
)
If you need the maximum value to be dynamic based on other slicers or conditions, consider creating a separate parameter table to define maximum values.
If this helped, a Kudos 👍 or a Solution mark would be awesome! 🎉
Cheers,
Kedar Pande
Connect on LinkedIn