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 below 

 

and when user opens second categories + icon it will show the unit category level which has background color for cell depending on a conditional formating rule as shown below 

 

 


But here you can see in second image even when i havent opened the second +icon it is not showing row total in some places but it is showing some background color 
as you can see below with red circles that its not showing row subtital but background color which i set up for cell color from conditional formating
from vbelow you can see issue is the red circle while it shoyld be someting like green circle

 

 



please help
GuyInACube 
amitchandak 
lbendlin 
Aldrin 
aj1973 

 

v-jiascu-msft 
v-jianboli-msft 

 

 

 

Need Help
Tips and Tricks

4 Replies

  • 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