Current Selection Display

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

Hi DuncanYeah - Create a new table in Power BI for the money range disconnected to main one.

calculated table as below:

Now Update your measure to refer to the slicer’s selected values (from MoneyRange), not the actual data table values.

concatenatex_cpe =
VAR mi = FORMAT(MINX(ALLSELECTED(MoneyRange), MoneyRange[Value]), "#0.0")
VAR ma = FORMAT(MAXX(ALLSELECTED(MoneyRange), MoneyRange[Value]), "#0.0")
RETURN
IF(
NOT ISFILTERED(MoneyRange[Value]),
"",
"[Money ($M)]: From" & UNICHAR(10) & mi & UNICHAR(10) & "to" & UNICHAR(10) & ma & " ; " & UNICHAR(10)
)

Now, your measure will reflect the full range selected in the slicer, regardless of whether there are actual data points for every value in that range.

Hope this works in your scenerio

Heya,

I don't really understand what you're trying to achieve but at least for the first topic you should create an additional table with the below formula:

Series = GENERATESERIES(0,100,1)

Then, connect the Value of this new table to the Money column in your table. Then use the Value as a filter in your visual (see below)

PS: the relationship is 1-to-1 because you have unique values in both tables. However, I assume in your real data you have repeating values in the Table so the relationship will change to Many-to-1.

Thanks you MNedix ,rajendraongole1 & Kedar_Pande .
Given that I'm working in direct query mode, creating an additional table using DAX isn't feasible. The real data spans from 0 to well over 3 billion values and beyond.

Any suggestions on how to navigate this situation would be greatly appreciated.

Thank You.

Best Regard,
Duncan