Solved: Dual KPI Visual

MANUELHORTA · ‎09-08-2017

Hello,

I downloaded the Dual KPI Visual at the office store and I have a question for you:

Is it possible to use the same indicator (eg: Gross Profit) with two different values, for example, on the bottom the value from last year and on the top the value from present year? If its possible, can you tell me how can I do it?

Hope you can help me 🙂

mede · ‎09-08-2017

Well, you can easily do it by putting "Gross Profit" and "Gross Profit LY" measures on Top and Bottom values with "Date" on Axis.

Perhaps your question is how to create a seperate measure for "Gross Profit LY" right? If that's the case, search the forum for "SAMEPERIODLASTYEAR" dax function.

Also you can refer to: https://msdn.microsoft.com/en-us/library/ee634972.aspx

Hope this helps:)

View solution in original post

mede · ‎09-08-2017

Well, you can easily do it by putting "Gross Profit" and "Gross Profit LY" measures on Top and Bottom values with "Date" on Axis.

Perhaps your question is how to create a seperate measure for "Gross Profit LY" right? If that's the case, search the forum for "SAMEPERIODLASTYEAR" dax function.

Also you can refer to: https://msdn.microsoft.com/en-us/library/ee634972.aspx

Hope this helps:)