Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I
Resolver I

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






Super User
Super User

@Sujit14496 , 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])

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 

colorweek 18 =
    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 
Week18 =
var wek = 18            
var b = IF(sales[status]="ongoing" || 'sales'[status] = "about to start",
            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

Please help 


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors