Presenting variance between actual 2018 and two other variables (budget for 2018 and actual 2017(ly)

[Arunas_R]

Hello everybody,

I'm creating a dashboard with card (OKViz from marketplace) containing net profit for current month and year to date and net profit for the same period of last year and variance between these. Now I wonder, if there any visualisation (similar to card) which can  simultaniously present variance between actual 2018, actual 2017 and budget for 2018 on the same card.

If there is no such a possibility, can please anyone advise the better way for preparing filter for variance calculation. I mean I want to make a filter with actual and BP button, which will switch the basis for calculation of variance in the card depending on the selected buttons in the filter. 

Thanks for help!

[v-jiascu-msft]

Hi @Arunas_R,

How about the Table visual with some measures? Can you share a sample and the expected results?

Best Regards,

Dale

[Arunas_R]

The problem is that I already have a bunch of cards on my dashboard and if I change the type of visual for something different than card, it will stand out from the whole picture. Also, I don't have a lot of free space to add another visual. Currently, the cards are shoving variance against last year. The ideal solution would be to add second variance against business plan, but I can't find anything appropriate. I think about making a filter, depending on which the variance will be shown either against last year or against budget, but I struggle to make it. I have three separate tables (actual 2017/actual 2018/BP2018) with such columns: Period/Entity name/Ebitda. There probably should be a formula similar to sumif with variable criteria depending on the item selected in the filter.