Issue on filter on Resource capacity analysis

Hi bslusars 

Thanks for the reply from suparnababu8 .

bslusars , I have a few questions to confirm with you. According to this sentence, "I created a calendar table 'TabelaDatas' to create my graphy by month." Is your calendar table just to make the x-axis of the line graph in months? If so, can you consider presenting it in the following form?

Put InitialDateCapacity in, select the hierarchy, and keep only Month.

The reason why there is data for February here is that I added data for February to the sample data you gave.

And this part of the formula, “(160 * SUMX('resource', VALUE('resource'[% of Capacity]))) / 100”,  is it the sum of each month * 160 and then divided by 100?

In my test, I used the InitialDateCapacity column as the x-axis of the chart and Slicer was applied normally.

Please feel free to correct me if I have any misunderstanding about your requirements. It would be even better if you can provide sample data of the calendar table and your expected results. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

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