Forum Discussion
Creating KRI dashboard with thresholds in Power KPI Matrix
On high level I understand what you are saying and I also figured formatting the KPI Indicators the way you explained.
The only prtion I am struggling is to writing the calculation and comparing it with threshold part. Can you give me one or two examples based on the data I provided? I mean writing the calculation part that goes into the cell. We can do one for below and one in the middle like you said.
Ok, to figure out with calculation column based on data from other columns and some constants I suppose you need to use such feature as DAX that is available in Power BI Desktop.
There is a topic where people discussed conditional calculations in DAX for instance.
Unfortunately, DAX is out of our expertise because it is a feature of Desktop, but you can ask questions regarding DAX in the Desktop thread.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]