Power BI: Ordered Categories
At my current company, we classify our customers by these words:
- Strategic
- Exploratory
- Priority
- Blue Sky
- Overhead
The order signifies how important they are (the earlier, the more important). Whenever they appear in Power BI, I want them to appear in this order.
The best way I've found to do this is to make a small table with all your attributes, and put an index.
On the fact table, put the index. This means, instead of putting "Strategic" there, put "1". This will allow you to rename Strategic later on. It also saves a lot of RAM and file size.