Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Show value as index?

Hi - in excel pivot tables, there's the option to show values as index. Is there the same option in power bi? Or do I have to write the index formulas? Thanks!

2 Replies

  • Anonymous , Not sure of any such option in power bi. Can you explain with example

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

    Nope, power bi supports less 'show value as' options than pivot table and it does not exist the option that you mentioned.
    I'd like to suggest you write a measure formula with custom calculation and grouping then you can use it instead.

    Regards,

    Xiaoxin Sheng