Forum

Can you use Measure...
 
Notifications
Clear all

Can you use Measures in Power Pivot model that are exported to Power BI to create graphs?

4 Posts
2 Users
0 Reactions
104 Views
(@jwr)
Posts: 4
Active Member
Topic starter
 

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

 
Posted : 19/04/2017 12:48 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 19/04/2017 6:58 am
(@jwr)
Posts: 4
Active Member
Topic starter
 

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

 
Posted : 20/04/2017 12:38 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 20/04/2017 7:38 am
Share: