Forum Discussion

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Share your thoughts on visual calculations (preview)

Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation.   Here are some areas that we'd like to hear ab...
General Comment
Branca32844's avatar
Branca32844
Frequent Visitor
1 year ago

Hi! Sorry, me again.. 
Is it possible to use a VC in a Card (new) visual, as a reference label?
It allows me to drop it in the reference label "Add label" section, but it doesn´t render into the visual.. 


Is this a limitation or I am doing something wrong?
Thanks!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Visual Calculations assume that you have tabular data. They don't make much sense for scalar data.

  • Branca32844's avatar
    Branca32844
    Frequent Visitor
    1 year ago

    I don´t agree.. They are very helpful for dynamic titles, subtitles, y axis max, all scalar values.

    So, why not reference labels..?

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      1 year ago

      this is likely just a temporary situation as we are planning to eventually have all kinds of places have the ability to use visual calcs. I am interested in your visual calc though, can you share it?

      • Branca32844's avatar
        Branca32844
        Frequent Visitor
        1 year ago

        Thanks for your feedback!

        Sure, this is the card and DAX expression I am using:

         

        Deals =
        VAR IconPositive = UNICHAR ( 9650 )
        VAR IconNegative = UNICHAR ( 9660 )
        VAR _measure = [Sales - Deals KPI]
        VAR Result =
            IF (
                _measure > [Sales - Deals KPI Vs],
                IconPositive,
                IconNegative
            )

        RETURN
        FORMAT(_measure,"#,0", USERCULTURE()) & " " & Result
        "
         
        I am using VC for the main measure, but also for the 3 month avg as a reference label (as a work around, I´ve added a dummy measure in the reference label section, turned off values and turn on a dynamic title with the VC).