Forum Discussion
Table Field Icons in the model screen
Hi,
I had just the same doubt, but digging through the IT Spend Analysis Sample PBIX file which can be downloaded from here.
In this case, you can find that traffic light icon in the fact table for the field "Actual/Plan":
It has three "child" fields within itself: Value, Goal and Status. None of them are measures or fields that can be found in the Fact table.
It is used in the page "Spend By Cost Elements", on the top left matrix, and Status is used to show a green, yellow or red spot depending on the relationship between the amount spent and the goal.
After messing around with almost every menu option on sight, not finding anything that was defining that particular part of the matrix, the fields, etc. within Power BI, i recalled that an excel file with a powerpivot data model and powerview tabs can be imported directly to power BI and converted to a pbix file.
I went to check the excel counterpart for "IT Spend Analysis Sample" and there it was:
Going to the powerpivot tab, expanding the KPI menu and selecting manage KPI, i was able to see where those fields i was seeing in powerBI (most probably) had been defined:
I hope this helps someone else with a similar doubt.
There might be other ways within power BI to deal with this, but honestly i wasn't able to find it!
Cheers.