Skip to main content
cancel
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

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

Sujit14496_0-1707446863121.png

as you can see above 
when i open these + icon it will show second category and its total as shown below 

Sujit14496_2-1707447117048.png

 

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 

 

Sujit14496_1-1707447058910.png

 


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

Sujit14496_4-1707447328449.png

 

 



please help
@GuyInACube 
@amitchandak 
@lbendlin 
@Aldrin 
@aj1973 

 

@v-jiascu-msft 
@v-jianboli-msft 

 

 

 

4 REPLIES 4
amitchandak
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 
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

Please help 

@amitchandak 

Helpful resources

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

PBI_Carousel_NL_June

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