Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visual displays the variation between 2 months

Hi team,   I'm looking for a visual to display the variation of a measure between the current month and the last month. Something like this  The visual will display in red color if the meas...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    You could get it by use three card visual to custom it.

    Create four measure as below:

    current month = CALCULATE(SUM('Table'[Value]))

last month = CALCULATE(SUM('Table'[Value]),PREVIOUSMONTH('Date'[Date]))

variation = [current month]-[last month]
    Icon = 
VAR theIndicator = [variation]
RETURN
   SWITCH (
            TRUE(),
            theIndicator >=0, UNICHAR(9650),
            theIndicator <0, UNICHAR(9660)
            )

    Drag [Current month], [variation], and [Icon] to three card visual.

    Now, in format pane, remove Category and set background is back.

    Then set conditional format for these three cards by the same logic for data label.

     

    Next, resize and position for three card visual to get your requirement.

     

    here is sample pbix file, please try it.

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous 

Build something very near to you want. You need have the arrow in middle. Arrow code and arrow color code

/////Arrow 
Arrow = 
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
            TRUE(),
            _change > 0, UNICHAR(9650),
            _change = 0, UNICHAR(9654),
            _change < 0, UNICHAR(9660)
            )


/////Arrow Color
Arrow color = 
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
            TRUE(),
            _change > 0, "green",
            _change = 0, "blue",
            _change < 0, "red"
            )

 

Link I have given in last update. The difference in conditional formatting I used field option and choose the measure

 

 

You can play with background-color etc