Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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.

 

 

 

 

 

Need Help
  • Icey's avatar
    Icey
    4 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Icey
      Community Support
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello Everyone 

    Any Update On This

    Is it Posible in Power BI Matrix Visual Using DAX?