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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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