Forum Discussion
Visual displays the variation between 2 months
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
Super UserNearest seeded is KPI visual. You might have to look in gallery for custom visual
@@amitchand
It is close to what I'm looking for but it doesn't work in my case because I would like to compare the current month to the last month and this KPI display 2 measures calculated in the same periode of time , by example the sales vs the target for each month.
Do you have something else ?
- amitchandak
Try Group visual. I think using image display you should be able to add that arrow
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2019-feature-summary/#grouping
Group 2-3 cards
Also refer : https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
- amitchandak
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