Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
wmeyer
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
Ashish_Mathur
Super User
Super User

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.
Anonymous
Not applicable

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.