How to show company total first, and then the departments?

[Anonymous]

Hello everyone,

I am posting this thread because I need some help with Power BI. I think it is simple and I am looking over it, but I just can't seem to realize what I want.

In my data I have the financial records of the departments of the company. I can display those nicely in a matrix. However, I want to FIRST display the company total (so the sum of all departments), and show the departments AFTER I click on the company total. The thing is however, my data does not contain a company total.

How can I realize this and make to show the company total first, and then the departments? after I click on the total first.

Here is the sample data: https://www110.zippyshare.com/v/tbLWB9NA/file.html

Thank you for your time.

[v-juanli-msft]

Hi @Anonymous 

I can't download your file or see any data from the link.

Best Regards

Maggie

[Anonymous]

@v-juanli-msft Hi Maggie,

Thank you for your reply. I checked the link on multiple devices, and all seem to work and open normally. Can you maybe check again?

If you still can not open it, it is structured like this:

Department (column) <--> Budget (column) <--> Actual(column) <--> Forecast(column)
Department A <--> 10 <--> 5 <--> 10
Department B <--> 9 <--> 2 <--> 8

Department C <--> 8 <--> 10 <--> 15

Department D <--> 7 <--> 8 <--> 10

Thank you for your time.