Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.