Hi,
We have build a number of huge Power Pivot models that uses both measures to find the data needed for reporting.
I am aware, that these measures are available when you export to Power BI.
But is it possible to create sparkline lookalikes based on a number of measures in Power BI?
best regards
Jørgen
Hi Jørgen,
You can create Sparklines with the custom visual from OkViz: https://okviz.com/blog/introducing-sparkline-for-power-bi/
You can use measures in your Sparklines, but I'm not sure if you have something particular in mind.
Mynda
Hi Mynda,
In Power Pivot we have created reports where our measures are almost completely driven by cubevalue formulas that are updated from Excel cells based on the filters chosen. That could be the numbers of full time employees in a department 2 month back in time - 1 month back - this month - estimate next month. where the month and a couple of other criteria is set in the filters.
So it is measures but filter driven.
I hope it makes sense?
regards
Jørgen
Hi Jørgen,
Only testing will tell if it will work for you or not once you load your model into Power BI. I don't have any cube formula measures I can test myself.
Let me know if you get stuck.
Mynda