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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

VISUALVALUE() context in DAX - Next level Dynamic FX formatting for visuals generically

Hi, 

 

Currently we're using a measure as the FX formatting for both the Call-out and Reference labels. 

For example:
"Format - Number of boxes =  SWITCH( TRUE(), [Number of boxes] = 1, "1 box", "# boxes")"
That format measure is put in the FX of the formatting of the Call-out value, which is great. 

 

However, for the Target a new measure is needed to be made, for example:
"Format - Target number of boxes =  SWITCH( TRUE(), [Target - Number of boxes] = 1, "1 box", "# boxes")"

 

The idea:

Instead of having to create many different measures for all kinds of - Actual Box(es),  Target Box(es), Actual Product(s), Target Product(s), Target Car(s) etc. etc. - this could be set up much more dynamically if the {object} of the visual, f.e. the {Callout value} could be called in a measure, so that it is not needed to explicitly say: "hey if this measure is = 1, then 'box', else 'boxes'", but that you can put in a measure format like: "If {value in current object} = 1 then '1 box', else '# boxes'"): 

 

For example:
"
Format - Boxes = SWITCH( TRUE(), {current object of visual} = 1, '1 box', '# boxes") "

 

That measure would then be free to be put in any FX of any format of any label of any visual. 

If [Format - Boxes] is put in the Callout Format FX it would automatically take the value of the field that is in the Callout value. If [Format - Boxes] is put in the Reference label Format FX it would automatically take the value of the field of the Reference label. Etc etc. 

 

I would see it as to expose a DAX function (e.g. VISUALVALUE() or extend SELECTEDMEASURE()) that, when evaluated inside a format FX expression on a card visual, returns the value of the measure bound to that specific visual slot (callout, reference label, etc.)

Status: New