column chart display last 3 weeks and 6 month

[froxas]

Hi,

I need to make a column chart what shows some invoice amounts on Y axis and on X axis it displays sequence by last 6 month and 3 weeks.

something like this:

January, February, March, Week 14, Week 15, Week 16.

Is it possible to do something like this in Power BI in one visual? 

Because now we are going to solve by adding to visuals side by side, one with month granuality and another by weeks granuality.

[v-juanli-msft]

Hi @froxas 

Please check my pbix.

If there is 0 value in week 15, 16, my visual show blank value instead of 0.

What results do you like?

Best Regards

Maggie

[mahoneypat]

Here is a trick you can use.  You can make add a column to your Date table that returns either month or week based on how close it is to Today() or whatever date you provide in the formula.  Here is an example where the first part returns true if the date on that row is in the current month and year.  Then in the second part, if true it returns week level detail with a "Week " prefix, and month detail if false.

MonthWeek =
VAR currentmonthyear =
AND (
MONTH ( 'Date'[Date] ) = MONTH ( TODAY () ),
YEAR ( 'Date'[Date] ) = YEAR ( TODAY () )
) 
RETURN
IF (
currentmonthyear,
"Week " & WEEKNUM ( 'Date'[Date] ),
FORMAT ( 'Date'[Date], "MMMM" )
)