Forum Discussion
Remove values in Matrix report row
Hi,
Is there any way of removing the highlighted values in a Matrix visualisation?
I'd like to display the country, and the Customers within that country, but only have the Amount for Country and not Customer.
The only other way I can think of is creating buttons that will take me to a seperate page to show the Customers?
Thank you in advance!
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Flag = IF( ISINSCOPE('Table'[Country])&&ISINSCOPE('Table'[customer]),BLANK(),MAX('Table'[Amount]))Measure = VAR _table = SUMMARIZE ( 'Table', 'Table'[Country], "_value", [Flag] ) RETURN IF ( HASONEVALUE ( 'Table'[Country] ),[Flag] , SUMX ( _table, [_value] ) )2. Result:
Or you can click Format -- Row headers -- to turn off the +/- icons so that only the value of [Country] is displayed
Result：
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
HI Anonymous - I would try using a Tooltip to show the list of customers when someone hovers over the Country amount. In you still want you matrix level with the +/- expand option you can consider update the behaviour of the Measure using ISFILTERED function. Try something like:
Amount No Customer Detail =
VAR _Amount = [Amount]
VAR _Filter = ISFILTERED( dimCustomer[Customer] )
RETURN
IF ( NOT ( _Filter) ,
_Amount , //Will show the total for country
DIVIDE ( _Amount, _Amount ) - 1 //Will show 0.00 for customer rather than amount or BLANK()
)You can play around with the false result to return empty text
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Flag = IF( ISINSCOPE('Table'[Country])&&ISINSCOPE('Table'[customer]),BLANK(),MAX('Table'[Amount]))Measure = VAR _table = SUMMARIZE ( 'Table', 'Table'[Country], "_value", [Flag] ) RETURN IF ( HASONEVALUE ( 'Table'[Country] ),[Flag] , SUMX ( _table, [_value] ) )2. Result:
Or you can click Format -- Row headers -- to turn off the +/- icons so that only the value of [Country] is displayed
Result：
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly