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
VickyDev18
Advocate II
Advocate II

Field Parameters in Reference Labels in the new Card visual not working

Let's say I have 6 metrics  Sales, COGS, Sales This Year, COGS This Year, Sales Last Year, COGS Last Year. 

 

I want the user to have 2 slicers

1. To choose between Sales or COGS

2. To choose between comparison to "This Year" or "Last Year"

 

If user selects Sales and This Year, the Card visual will show Sales as the main metric and Sales This Year in the reference label area. 

If user selects COGS and Last Year, the Card visual will show COGS as the main metric and COGS Last Year in the reference label area. 

I thought I would be able to achieve this using 2 Field Parameters but looks like Field Parameters don't work for Reference Labels. Is that correct or am I missing something? 

VickyDev18_1-1715601692195.png


Here's a link to a sample PBIX file. 


 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @VickyDev18 ,

 

Currently you cannot use field parameters in the reference or the card since has you can see it will return the first value and not the value itself for this you need to create a switch measure:

Reference = SWITCH( TRUE(),
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  0 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =0 , [Sales This Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  0 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =1 , [Sales Last Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  1 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =0 , [COGS This Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  1 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =1 , [COGS Last Year])

 

See PBIX file attach.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

3 REPLIES 3
kaisrec
Advocate I
Advocate I

Besides Field Parameters, Calculation Groups also do not work with the new Card visual's reference labels. This limitation means we can't dynamically switch the reference labels values using these features.
A workaround is to use a Dynamic Measure that utilizes the SWITCH function, as demonstrated in the post, by @MFelix
Hope Microsoft adds support for Field Parameters and Calculation Groups in the reference label section of the Card visual in future updates.

MFelix
Super User
Super User

Hi @VickyDev18 ,

 

Currently you cannot use field parameters in the reference or the card since has you can see it will return the first value and not the value itself for this you need to create a switch measure:

Reference = SWITCH( TRUE(),
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  0 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =0 , [Sales This Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  0 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =1 , [Sales Last Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  1 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =0 , [COGS This Year],
    SELECTEDVALUE(_Param_Metric[_Param_Metric Order]) =  1 && SELECTEDVALUE(_Param_CompareTo[_Param_ComapreTo Order])  =1 , [COGS Last Year])

 

See PBIX file attach.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks @MFelix . 

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.