Percent of category per department

[Peavey]

I am trying to figure out a way to solve the following: 

There are several departments with hours spent, the hours have two different categories and I need to show per department according to the category in percent. My ultimate goal is to show a trend of the development of the hour category per department.

I can get the hours by dep and category, but when I choose to show it in percent, the only option is of GRAND TOTAL, and not per department.

Any tips for me?

Thanks,

A

[v-xicai]

Hi  @Peavey ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Peavey ,

You can create measure like DAX below, then put the measure onto Value box of Clustered column chart.

Percentage Hour= DIVIDE (CALCULATE(SUM(Table1[Hours]),FILTER(ALLSELECTED(Table1), Table1[Dep] =MAX(Table1[Dep])&&Table1[Category] =MAX(Table1[Category]))), CALCULATE(SUM(Table1[Hours]),FILTER(ALLSELECTED(Table1), Table1[Dep] =MAX(Table1[Dep]))))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VijayP]

Try using Matrix instead of Table and you Will get more options . Still face problem please let me know

[Peavey]

---

@VijayP wrote:

Try using Matrix instead of Table and you Will get more options . Still face problem please let me know

---

Thanks for the tip, I have tried that but it does not make me able to visualize it as an trend. I have data for each week. 

Any idea how I can do that?