Matrix Visual - show and hide columns related to each step

[Anonymous]

Using a Matrix Visual, is it possible to get this type of effect:

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Please try this workaround

create the measure below to replace [First App Desc] column

First App Desc Measure = 
var _firstapp= FIRSTNONBLANK(SELECTCOLUMNS(FILTER(ALL('Table'),'Table'[App]=MAX('Table'[App])),"sub app",[Sub App]),[sub app])
return IF(MAX('Table'[Sub App])=_firstapp||NOT(ISFILTERED('Table'[Sub App])),MAX('Table'[First App Desc]),BLANK())

before

after

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This solves my main problem. Thank you so much.

[Anonymous]

Thank you so much. I do have my sample file but I don't see an option on how to attach.

But this is pretty close to the solution, only thing is if the AppDesc1 could be on the row that has App1 when it is maximised

I'm not sure if I'm just missing the attach file option or if I don't have it since I'm new.

[amitchandak]

@Anonymous ,

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc