cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vanessa Member
Member

Is it possible to create a similar report/visual?

I want to create a visual/ table report with indicators like the following (the one highlighted in green). Is this possible??

report.png

 

 

13 REPLIES 13
Super User
Super User

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

@vanessa are you after traffic light indicators in powerbi ?

Super User
Super User

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

@vanessa Unfortunately you have to do this in PowerPivot and then import to PBI

the feature is described here => https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/

 

KPIs.png

 

So ANYONE who wants to be able to create the KPIs inside PBI

Please Vote here

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8276622-create-kpi-in-designer-fi...

vanessa Member
Member

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

@Sean

 

I tried the approach mentioned in the link, but I am not able to see the option Preview Features > Use KPIs from Power Pivot or SSAS Tabular in the Option and Setting tab. Is thia preview feature no longer available?

 

Preview Features.png

Super User
Super User

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

@vanessa It seems this feature has been enabled by default in the latest PBI - so don't worry it will work!

 

However don't forget you still have to create the KPIs in Excel PowerPivot and then import into PBI

 

 

 

vanessa Member
Member

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

@Sean

 

That worked. Thanks.

But after importing the excel sheet, all my earlier report pages have disappeared and not all tables/files have been migrated. Is there a reason for this? Do i need to recreate all the pages again?

Super User
Super User

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

@vanessa Yes the process is kind of frustrating.

 

Only Power View Excel Sheets get imported - and not even all Power View visualizations are supported.

 

That's why I encourage people to Vote and hopefully the PBI Team will get behind the Idea of KPIs inside PBI.

 

They just recently marked "Under Review" one of my Ideas - which will go great with KPIs

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9207006-matrix-collapse-expand-bu...

 

So hopefully it's just a matter of time Smiley Happy

vanessa Member
Member

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

@Sean

 I closed and re-opened my pbix file in which i imported the Excel sheet. But the KPI field is no longer available. Any idea about this?

Super User
Super User

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

@vanessa I have not encountered this but I'll see if can duplicate it tomorrow - will let you know...

 

its strange though??? Is the rest of your data still there and only the KPI Measure(s) gone?

vanessa Member
Member

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

@Sean

I deleted the file and created a new 1. I did not encounter the earlier issue. The KPI is available even after closing and re-opening.