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

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.

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

    Hi SillyJam123,

     

    To show images in table visual, you should store the image URL into data view table, and set its category to "Image URL".

     

    Have you resolved your original problem? If so, please kindly mark the corresponding reply as an answer so that it can benefit some other users. If you have some more questions about creating Power BI reports, please post your questions as a new thread so that you can get more help from more community members.

     

    Best regards,
    Yuliana Gu