Forum Discussion
Dannismen
Helper I
2 years agoChange Hierarchy order in Matrix
Hi, I'm struggling to change the hierarchy order in matrix. I want the KPI name to be the first level and then CW/PY/PY% so it will show each KPI with its time intelligence features. Name is the...
Daniel29195
Community Champion
2 years agocreate an order column in power query
example :
name order
kpi 1
CW 2
PY 3
PY% 4
then in power bi , go to table view,
select the column Name, and sortby order column .
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠