cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

what data is needed in the excel file that i upload to BI to show goals for kpi visual

I'm working on creating a KPI visual on my dashboard. From reading other posts, I've gathered that I need to create an exel file with my KPI goals and upload that to BI, and add it to my table. 

What information/format do I need to put in that excel file?

 

I'm brand new to BI, so understanding the inormation needed in the queries to be able to do what I need to in the visuals, is still something I'm trying to figure out.

 

4 REPLIES 4
Super User III
Super User III

Hi,

 

Please elaborate your actual business requirement.  What does your data look like?  Whar result are you expecting?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I'm creating a visual to show what % of items we had go out of stock last month. I wanted to use the KPI visual, and show the number that went out of stock in comparison to our goal. I have the data pulled together to show the number of items that went out of stock each month, but I cant figure out how to pull the goal % of items in the KPI indicator. 

 

 

Hi @wmeyer,

 

Based on your description, I think kpi visual not suitable for your requirement.(kpi visual only support to analysis summarized values)

Perhaps you can take a look at below links:

USE KPI IN TABLE, MATRIX AND CARD VISUALISATIONS IN POWER BI

Inline KPI behaviour

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

You will either need to create a Relationship to your Goals table, or integrate the data from the Goals table into your original data.

 

My choice would be to add a Calculated Column to the original table that shows the Goal value for each row.  You should then be able to set that value in the KPI vis.

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors