Forum Discussion
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, B, C. Each of these categories have D, E, F and each categories have 1, 2, 3, 4, 5 up to ex number of data.
Each of the 1, 2, 3, .. has progress captured by percentage and are delivered on different dates.
My task is to display D, E, F in vertical view with 1, 2, 3, 4 as individual columns as heatmap but only showing percentage completion as bar and dividing the view by A, B, C ..
Following, is my poor attempt to draw possible display ..
| A | B | C | |
| D | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | |
| E | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | |
| F | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | | 1 | 2 | 3 | 4 | |
Thankyou to everyone in advance 🙂
KP
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.
5 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi 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.
Hi MStaford,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi MStaford
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thank you.
