Forum Discussion

MStaford's avatar
MStaford
Regular Visitor
1 year ago
Solved

Creating a brick view

Hi everyone,    I am trying to build a view to show heatmap like structure for categories and sub-categories with a view divided by a third category.   For example, have one column with values A,...
  • v-sgandrathi's avatar
    1 year ago

    Hi MStaford,

     

    Thank you for your query.Based on your requirement, we have successfully replicated the scenario in Power BI using your provided dataset. The output is a matrix visual that resembles a brick-style heatmap, where:

    • Rows represent MidLevel values (D, E, F),
    • Columns are a combination of TopLevel and Item.
    • Each cell shows the Progress % using a data bar, giving a clear and intuitive visual of completion across categories,
    • This layout enables easy tracking of performance across multiple hierarchy levels.

    The matrix uses conditional formatting to display progress bars inside the cells, and provides a concise overview of your data in a compact, structured format.

    I’m attaching the .pbix file with all the steps implemented, so you can explore, customize, or extend it further as per your needs.

     

    If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

     

    Thank you.