Forum Discussion

SillyJam123's avatar
SillyJam123
Frequent Visitor
9 years ago
Solved

Multiple dimension report

Hi,   I need to create a report that has multiple dimensions and one measure. For example, continent -> country -> state --> city -> revenue OR Vertical -> portfolio -> sub portfolio -> project cat...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi SillyJam123,

     

    You can insert a matrix preview and add corresponding columns into Rows section like below. By click the button on the top left which is highlighted in red, you can drill ddown to each level.

     

    If you cannot see the matrix preview in Visualizations pane, Please go to File -> Options and Settings -> Options.

    Best regards,
    Yuliana Gu