Display Month-wise and Current month of weeks data in one visual

[Anonymous]

Hi Guys,

I am trying to display Month-wise and Current month of weeks data in 100% stacked column visual, which I am not able to do it now. Is there any provision to do this in Power BI?

I have attached a sample snapshot with this, that I want to achieve in power BI. Please suggest  DAX.

Thanks

Godasu

[amitchandak]

@Anonymous ,

DO you have month week. That will give you that. But I doubt the first Bar, what is that

[Anonymous]

i have a month column and week column .. How to write  dax Month week in a single column 

Thanks

Godasu

[Anonymous]

For Example I Have a month column and week column and product column and Sales Column

in power bi i full the Axis level -->Week number (I need Month And week number)

                                Legend Level --> product 

                                Value Level --> Sales  

then power bi showing sales by week number and product 

But I need a  sales by Month and week number and product  

[v-eachen-msft]

Hi @Anonymous ,

Could you please share your sample data and expected result to me if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.

[Anonymous]

Thanks for your Reply 

for example--April-20 you have selected in slicer and in that Single visual it should show month April-20 data & week data for w1,w2,w3,w4 of April-20

(if you Have select 1/feb/2020 to 30/March/2020 It Will display selectd months(Feb and March and April) And current month(April) of week1 week2 week3 week4 week5)

Sorry for the inconvenience i dont have one drive permission in my Laptop.

Dax- 

WeekiMonth = 1+WEEKNUM('P6-OfficeSupplies'[OrderDate])-WEEKNUM(STARTOFMONTH('P6-OfficeSupplies'[OrderDate]))

WeekiYear = 1+MOD(WEEKNUM('P6-OfficeSupplies'[OrderDate])-1,52)

OrderDate	Item	Units
4-Jul-19	Pen Set	62
12-Jul-19	Binder	29
21-Jul-19	Pen Set	55
29-Jul-19	Binder	81
7-Aug-19	Pen Set	42
15-Aug-19	Pencil	35
24-Aug-19	Desk	3
1-Sep-19	Desk	2
10-Sep-19	Pencil	7
18-Sep-19	Pen Set	16
27-Sep-19	Pen	76
5-Oct-19	Binder	28
14-Oct-19	Binder	57
22-Oct-19	Pen	64
31-Oct-19	Pencil	14
8-Nov-19	Pen	15
17-Nov-19	Binder	11
25-Nov-19	Pen Set	96
4-Dec-19	Binder	94
12-Dec-19	Pencil	67
21-Dec-19	Binder	28
29-Dec-19	Pen Set	74
6-Jan-20	Pencil	95
15-Jan-20	Binder	46
23-Jan-20	Binder	50
1-Feb-20	Binder	87
9-Feb-20	Pencil	36
18-Feb-20	Binder	4
26-Feb-20	Pen	27
7-Mar-20	Binder	7
15-Mar-20	Pencil	56
24-Mar-20	Pen Set	50
1-Apr-20	Binder	60
10-Apr-20	Pencil	66
11-Apr-20	Pencil	75
9-Apr-20	Pen	96
5-Apr-20	Pencil	90
12-Apr-20	Pencil	53
5-Apr-20	Pencil	32
14-Apr-20	Binder	80
8-Apr-20	Binder	60
14-Apr-20	Desk	5
15-Apr-20	Pencil	90

Thanks

Godasu

[Anonymous]

Depending on the image, two visuals to display a single visual (100% stacked column)

[Anonymous]

i Have a colums as month and week, first Bar is month of (March-2020)