I am a new user for Power BI. I dont have any big information or ideas about this tool. So i would like to ask help on experts on this tool.
My Manager would like me to create a KPI tool using Power BI but the problem is i dont know how to do this.
As shown below, it is a sample of KPI repoting which my manager would like me to do but i dont know how to do it
Can please anyone help me on this or any points that might help me start this one.
Go to Solution.
Based on my test, you could refer to below stesps:
Create a measure to show the KPI:
KPI = IF(MAX('Table1'[Current Cost])<MAX('Table1'[Prev Cost]),UNICHAR(8601),IF(MAX('Table1'[Current Cost])>MAX('Table1'[Prev Cost]),UNICHAR(8599),UNICHAR(8596)))
Use the conditional formatting function to modify the [Complete] column:
You could also download the pbix file to have a view.
View solution in original post
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!