Forum Discussion
Matirx Visual in Power BI
Hello Friends I have a matrix visual which has stepped layout with +/- icon for power bi as you can see above when i open these + icon it will show second category and its total as shown ...
Hello amitchandak
as i have 52 columns in matrix as of 52 weeks of year ,
i am using calculated column for every week for conditional formating
example
colorweek 18 =
SWITCH(
TRUE(),
RELATED(sales[Week18])=1 && RELATED(sales[type])="A", 1,
RELATED(sales[Week18])=1 && RELATED(sales[type])="B",2,
RELATED(sales[Week18])=1 && RELATED(sales[type])="C",3,0)
and the week is also a column
like
and the week is also a column
like
Week18 =
var wek = 18
var b = IF(sales[status]="ongoing" || 'sales'[status] = "about to start",
IF(
sales[startdate] <= ((TODAY()+(7*(Wek-1))) - WEEKDAY(TODAY()+(7*(Wek-1)),1)+ 1)+7
&& 'sales'[enddate] >= (TODAY()+(7*(Wek-1))) - WEEKDAY(TODAY()+(7*(Wek-1)),1)+ 1 ,1,0),0)
return b