How to build sub reports visual?

Hi,

I am new to Power Bi. I am asked to create a hierarchical report for senior management. The first level should be just color coded (Green = no problem, Yellow = possible problem, Red = Problem) based on given criteria.

When user clicks on Red, it drills down and shows more details such as tile report in a new report in a second level.

When user clicks on specific tile, it should show detailed report as a new report/page in a third level.

I know basic functionality of powerbi but don't know how to proceed further. Can someone give me a good start point about how to color code the reports and create sub reports on the fly? Is this possible in power bi?  Thanks a lot in advance.

Prashant-

Hi ppgandhi111,

Generally in Power BI Desktop, if we want to create sub-reports, we can try Drill Through option. 

Reference: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2017-feature-summary/ 

https://www.youtube.com/watch?v=2x9lLHDbtDk 

Thanks,
Xi Jin.

I would like to use Treemap chart for showing hierarchical data. For example, based on the total sales, the following Treemap chart has three levels Tag->Region->Product information.