Show value as index?

[Anonymous]

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!

[Anonymous]

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

[amitchandak]

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