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

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?