cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
etshao1947 Regular Visitor
Regular Visitor

Re: Is it possible to create a similar report/visual?

Hi Sean, 

 

I have followed your instruction and created kpi in powerpivot. 
When I import to PBI desktop, the kpi (or the pivotpivot table) is not found. But when I import to PowerBI onilne, the kpi is there. 

May I know how to correct this?

 

Many thanks.

Super User
Super User

Re: Is it possible to create a similar report/visual?

Are you using the latest version of the PBI Desktop?

 

2.34.4372.501 64-bit (April 2016)

 

If not you may have to turn on the Preview Features (see Vanessa's post and picture on Page 1)

ireneapplebe Frequent Visitor
Frequent Visitor

Re: Is it possible to create a similar report/visual?

Hi, I'm trying to create traffic light indicator and I have data model already created using Powerviot.

After created data model using Powerviot, I have created KPI spreadsheet and this is loaded to PowerBI.

However, when I create table using data source loaded, it does not show traffic light indicator but showing "-1" or "1" value instead.

Can anyone let me know how should I go about this?

 

Thanks in advance!

ireneapplebe Frequent Visitor
Frequent Visitor

Re: Is it possible to create a similar report/visual?

In your screenshot, I'm seeing infront of one measure "traffice light" icon is displayed. How can this be achieved?