Forum Discussion
Need To Remove(hide) Specific Rows From Matrix Visual in Power BI
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.
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.
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.