Forum Discussion

MarieJ's avatar
MarieJ
Regular Visitor
9 years ago

how can I insert fixed integer in series?

Hi, I am very new to Power BI, and have lots of questions. Is it possible to insert fixed integer in series like {1..27} above red rectangle. Either Quantity or Sales Amt would be sorted, the...
Need Help
MarieJ's avatar
MarieJ
Regular Visitor
9 years ago

Dear Victor,

 

Thank you so much for your reply.

I tried add index, but it didn't work..

 

The reason why I want to have fixed integer is like below,

Rank is fixed, and Sales name, Quantity, Amount can be changed,

 so I can see who is No.1 for Quantiy, who is No.1 for Amount with one fixed column.

 

is this truely impossible? T.T

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

MarieJ

 

My last solution, is very simple but work in some scenarios

 

1. Create a Table  with 1 column from 1....27 values

 

Put in a table Visual

 

2. In A different Table Visual put the other columns., Try to look like a single table.

 

  • MarieJ's avatar
    MarieJ
    Regular Visitor
    9 years ago

    wow, it looks wonderful!!!

    this is truely simple and good!!

    Thank you sooooo much Victor!! ^__^

     

    But if the list is over 43, I should scroll down rank table, and sale table seperately ^^;;;

    and if the list is a lot, it's quite difficult to scroll down with same position T.T