Forum Discussion

Dannismen's avatar
Dannismen
Icon for Helper I rankHelper I
2 years ago

Change 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 time intelligence functions created by tableau editor that contains CW, PY, PY%, etc. Please do not suggest to change the underlying data model or existing measures. Thank you!

 

 

Need Help
Tips and Tricks

4 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Dannismen 

    create 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! 🤠

     

    • Dannismen's avatar
      Dannismen
      Icon for Helper I rankHelper I
      2 years ago

      Sorry. It didn't work. Name is actually time intelligence name, and KPIs are all separated by each measure, not colunms. Thanks. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Dannismen 

     

    What I want to make sure with you is that your KPI is a measure? If so, after my testing, measure can't be a row of matrix, you can try if you can show the KPI in a calculated column.

     

    Best Regards,
    Community Support Team _Yuliax

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.