Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In the "Corporate Spend sample for Power BI" rom Microsoft, in the Flag table, there is a group called "Actual/Plan" that has three measures:
How were these built? Or are these measures or something else? How can I see their definitions?
When I click on them, I do not see any Measure definition, DAX.
Thanks for any replies.
Solved! Go to Solution.
Hi @jafrick100 ,
It is not directly viewable on Power BI Desktop, you can use an external tool, Tabular Editor, to view it.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jafrick100 ,
After import into Power BI, your KPI will appear in the Fields pane, marked with the icon. To use a KPI in your report, be sure to expand its contents, exposing the Value, Goal, and Status fields.
Please refer to the following document for more information.
Import and display KPIs in Power BI - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Neeko,
Thanks for post. We are already able to open the pbix and see the measures for Value, Goal, and Status.
My initial post was that we can not see any details about the measures, no definitions or anything. I look in the model and in the data files themselves. I could find nothing.
Plus, if you look at the screenshot I did, these three are under ACtual/Plan. This is not a Display folder, I don't think. Plus it has the broken arrow symbol to the left of it. What does that symbol mean.
Thanks again for posting,
James
Hi @jafrick100 ,
This arrow symbol means that this is the KPI. it contains three fields.
Imported KPIs are best used in standard visualization types, such as the Table type. Power BI also includes the KPI visualization type, which should only be used to create new KPIs.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Neeko,
Thanks for the post. It is expanding my knowledge.
I still cannot see the definitions of Value, Goal, and Status.
I figured out Value and Goal simply be adding them to a table, adding measure to the table, and comparing Value and Goal to measures. I cannot find a way to show the definition of Goal. I am fairly sure it is some sort of DAX, but where is the definition?
Thanks for the post.
James
Hi @jafrick100 ,
It is not directly viewable on Power BI Desktop, you can use an external tool, Tabular Editor, to view it.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the initial post I wrote, "... in the Flag table, there is a group called "Actual/Plan"...".
That should read, "... in the Fact table, there is a group called "Actual/Plan"..."
Here is a screenshot of the Fact table and the measures I am talking about. By the way, what is the crooked arrow icon to the left of the words Actual/Plan?