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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
tomperro
Helper V
Helper V

Using a measure within a parameter

Is there a way to have the first part of the parameter definition show the end date of a dates between slicer?
I would like to grab 4/17/2024 from the slicer and use it in the first part of the paramter.

tomperro_0-1728501511805.png

 

I have a measure ([SelectedEndDate]) that gets me 4/17/2024 but when I use this in the paramter, it just returns the max date of my table and not the selected slicer value. 

SelectedEndDate = MAX(DateSelectionTable[DateTime])

 

 

Parameter 3 =
VAR ColumnHeaderName =[SelectedEndDate]
RETURN
{
    (ColumnHeaderName, (NAMEOF([SelectedEndDate])), 0)
}
3 REPLIES 3
lbendlin
Super User
Super User

Parameters are predefined, immutable and cannot be changed by measures.

 

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

Thank you. 

I am trying to dynamically update my table matrix headers using paramters.

I would like the headers to updated based on slicer selections.
Example:

tomperro_0-1728504498606.png

 



Selected End Date
Count for 4/2024
Month Prior to Selected Date
Count for 03/2024
Entire Date Range Selection
Count for 7/2023- 7/2024
65465654987654321

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.