Custom Column Chart to display Years, months, WEEKS ,and YTD in Power BI

[canuto90]

I've been working in obtaining this visualization for my KPI's company meeting. They want to see years, months and weeks in the same axis. My problem is that I'm not getting the right data for the latest 4 WEEKS category.  The correct solution (latest 4 WEEKS) should be related with the LATEST current date -month (in this case the month of May). The results that I 've got I think are a for other weeks, not just may month. The sum of the 1,2, 3,or 4 weeks should match the latest month.

I have 3 tables. My calendar table, a Fact table (Table2) and a Time intelligence Table. Any help would be really apreciated.

Calendar TableTime Intelligence Table

[v-xiandat-msft]

Hi @canuto90 ,

Ensure that the relationships between your Calendar Table, Fact Table (Table2), and Time Intelligence Table are correctly set up.

Unreasonable relationship settings will cause errors in the screening results.

If the result is incorrect after setting the correct relationship, please send your pbix file. Thank you

Best Regards,

Xianda Tang

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

[canuto90]

Dear V-xiandat-msft. On my time intelligence table I have just references to the time axis, not dates. I don't know how to establish a relation between those tables. The file is attached. https://1drv.ms/u/s!Av-mvq2itXCwgo9bjswujhV63w2cPA?e=LigCR5   . Thank you very much for having a look.

Spoiler

Spoiler