Advanced Data columns in a table

[IPGeorgiev]

Hi all,

I am quite new to Power BI and I have one report which I would like to automate if possible.

This is a table which in terms of rows is easy to configure, however in terms of rows its a bit hard.

In the raw data we have - Day, Month, Week, Year as separate columuns so that we we want to achieve is a table which looks like this:

It like if we are able to have columuns with a week value which can be expanded to daily value.

Hope I managed to explain what we need.

Many thanks in advance!

BEst regards,

Ivan 

[IPGeorgiev]

I have some progress..

I found this feature "

Drill down on column headers"

The issue now is that I cant get the Weeks in the Data Hierarchy.

Thats what I have displayed in the fields section:

And heres what I have in the raw data:

Now if I use Month, Week, Date it gets confused and shows the months as follows - December, February, January

If I get the time hierarchy I dont have the weeks. 

Any advices?

many thanks!

[v-yuta-msft · Accepted solution]

@IPGeorgiev ,

You can use the WEEKNUM() function:

WEEKNUM(<date>, <return_type>)  

https://docs.microsoft.com/en-us/dax/weeknum-function-dax

Community Support Team _ Jimmy Tao

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

[IPGeorgiev]

Hi, thanks for the reply! This works and adds the week, however still doesnt manage to get a good visual in Power Bi Matrix