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

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).
jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

thanks for sharing, it is great to see your usage of visual calcs.