Need To Remove(hide) Specific Rows From Matrix Visual in Power BI

[Anonymous]

Hello All,

I have following Matrix Visual with Field ROWS have 2 Attribute DIM_Program and DIM_Business and COLUMNS have 1 attribute containing last 4(Green) column header and in VALUES field i have  Account Strategy,Technology Support,Transparency(CBI) measure name. My Requiremnt is to show Measure Name "Technology Support" with respect to "DIGITAL_EXCELLENCE" and "Account Strategy" and "Transparency(CBI)" with respect to "MARKETING & SALES EXCELLENCE". How We can do this in Power BI using DAX.

[Anonymous]

Hello Everyone 

Any Update On This

Is it Posible in Power BI Matrix Visual Using DAX?

[Anonymous]

Hello All 
Lets I Explain to you one more time what i exactly want in my above Post.

I wanted to hide some specific rows value in matrix visual. to show only rectangular highlighted rows. Finally my output look like following. I want to remove unrectangular rows from my matrix visual in Power BI.

With Respect to 

Country = Canada i want to show "Profit" Measure Only and for

Country = France i want to show  " Sales Price" and "Unit Sold" Measure.

Product would be as it is.

[Icey · Accepted solution]

Hi @Anonymous ,

---

---

Based on your screenshot, try to create measures like below:

Profit Measure =
IF ( MAX ( 'financials'[Country] ) = "Canada", SUM ( 'financials'[Profit] ) )

Sales Price Measure =
IF (
    MAX ( 'financials'[Country] ) = "France",
    SUM ( 'financials'[Sales Price] )
)

Unit Sold Measure =
IF ( MAX ( 'financials'[Country] ) = "France", SUM ( 'financials'[Unit Sold] ) )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.