Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
2 years ago

Anonymous , Not sowing subtotal can be because of row context used in measure like

if(Max(Item[Category]= "ABC"

or if you have used hasonevalue, isfiltered or isinscope

 

For that, you have to share the measure used.

 

Usually, we fix row context issues by creating a new measure on top of your column with all applicable group bys (row/column field).

 

Sumx(Summarize(Fact, Dim[Col], Dim2[Col], "_1", [Measure), [_1])

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 
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