Forum Discussion
mp390988
Post Partisan
Post PartisanHow to combine to matrix visuals
Hi, Is there a solution or a way that I can combine to seperate matrix visuals together that share the same column headers? So for example, in this image below, you can see I have two different ma...
You will need to disable the total row and a custom total row to the column you're using. Total will always be on the bottom or top depending on the visual. You can conditionally format the text color or the background to highlight the total.
total background = IF ( tbl[tradetype2] = "Total", "#eeeeee" ) --to be used as field valueYou will also need to use dynamic format strings to apply a different for mat to %. Example:
IF ( tbl[tradetype2] = "%", "0%", "0,0" )
Create new table that lists all the rows you want to display in your matrix , including total, and KPI rows like RevTargets. Then, write a DAX( SWITCH ) measure that returns the correct calculation for each row based on its type, and add it the Value of the matrix.