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

jmdh's avatar
jmdh
Advocate IV
9 years ago

 

If i understood you, you want to show budgets par broad categories and then zoom in (sevarl times)

 

I would think a ccombination of Herarchy and the new Matrix visual in Preview should do.

 

If you had sample data i could check.

 

JM

jmdh's avatar
jmdh
Advocate IV
9 years ago

Hi I was about to post the sample solution, but i see an other community member has been faster than me.

Thanks.

 

  • SillyJam123's avatar
    SillyJam123
    Frequent Visitor
    9 years ago

    Thanks v-yulgu-msft and jmdh. Is it possible to have something like below:

     

     PP1PP2PP3PP4
    Vertical by Portfolio by Sub-Portfolio1020315

     

    Here Vertical by Portfolio by Sub-Portfolio is expandable something like Hierarchy, and counts under the Project Phase (PP1,PP2...) varies as we expand/collapse?

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      9 years ago

      Hi SillyJam123,

       

      Curently, expand/collapse is not a supported functionality for visual. This requirement cannot be achieved now.

       

      Regards,
      Yuliana Gu

      • SillyJam123's avatar
        SillyJam123
        Frequent Visitor
        9 years ago

        hi v-yulgu-msft how can we add images to table view? I got image filter as part of chiclet slicer, now I want to show those in the table.