Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
Hi,
Please elaborate your actual business requirement. What does your data look like? Whar result are you expecting?
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
Regards,
Xiaoxin Sheng
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |