Forum Discussion
Helper IRevenueTY Measures Hierarchy in Customer Profitability Sample
Hi,
Does anyone know how the RevenueTY Hierarchy has been created in the FACT Table in Customer Profitability Sample pbix? It contains the fields VALUE, GOAL & STATUS under it and has a LED indicator next to it?
Thanks
- Hi ,
Right now I'm not near a computer but if you are talking about the hierarchy showing in the field list since you are refering to a field with a led indicator this is done by datasources that come from excel powerpivot in wich it was created a kpi with led. When you upload that powerpivot table to PBI it also brings the led kpi.
Regards,
Mfelix Hi powerrdl,
It seems like a kpi measure hierarchy, perhaps you can take a look at following blog about create a kpi measure in powerpivot:
PowerPivot KPIs – Part 3 of the PowerPivot 2012 Series
Regards,
Xiaoxin Sheng
4 Replies
- MFelix
Super User
Hi ,
Right now I'm not near a computer but if you are talking about the hierarchy showing in the field list since you are refering to a field with a led indicator this is done by datasources that come from excel powerpivot in wich it was created a kpi with led. When you upload that powerpivot table to PBI it also brings the led kpi.
Regards,
Mfelix Hi powerrdl,
It seems like a kpi measure hierarchy, perhaps you can take a look at following blog about create a kpi measure in powerpivot:
PowerPivot KPIs – Part 3 of the PowerPivot 2012 Series
Regards,
Xiaoxin Sheng
powerrdlHi Xiaoxin Sheng,
Many thanks for your response !
Is there a way to dynamically define KPI Indicators (similar to what's defined in powerpivot) in Power BI based on the current context and measures values rather than creating calculated column at the data model level ?
Thanks and Regards,
Rameen Dhall
Hi powerrdl,
Power bi not support kpi, about this requirement, you can try to write a measure to check value and use arrow characters to show the result.
Reference link:
How to add an Indicator to Power BI Desktop
Regards,
Xiaoxin Sheng