Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can we change column order?

Hi,

I hope to chage column order 5G-LTE to LTE-5G.

As far as I know, there is no such this option unless we put order number like 1)LTE-2)5G.

 

Any idea please?

 

Also any measure or solution to change column color respectively?

It has only one value item so specific column option doesn't help. 

 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks

4 Replies

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Icon for Super User rankSuper User
    2 years ago

    Anonymous 

    Assuming you are using Power BI Matrix visual. 

    For changing the coumn order, as you have rightly mentioned sort order column is required to change the order of the columns. 

    Considering you also have a requirement to have a different column for each column, why cannot you consider creating three different measures? 1. 5G, 2. LTE and 3. Total. This way you will be able to put them in a desired order and can choose a desired color.

     


    If the post helps please give a thumbs up


    If it solves your issue, please accept it as the solution to help the other members find it more quickly.


    Tharun

     

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    Hi Anonymous 
    According to order, you need to add an "order column" and sort the categories from the table view :

    Unfortunately, we don't have the functionality to set different backgrounds for column headers based on color. However, there are alternative options available

    1. Add 3 shapes under the matrix:
    (with better design my sketch is just shows how it works technical)

    Or to create separate measure for every category :

    Ct = CALCULATE([measure_],'Table'[Category]="CT")
    LTE = CALCULATE([measure_],'Table'[Category]="LTE")
    5G = CALCULATE([measure_],'Table'[Category]="5G")

    In this case, you can design every column as you need :

    Pbix with all examples is attached

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