is it possible to make this big cross table ?

[Cobra77]

hi

is it possible to make this big cross table ?

with a ssas tabular server behind ?

every number here in the table would be a measure.

If yes with component?

And it is possible to hide a column with a parameter ?

And column name dynamic ? (measure?)

And in the end the use would be in power bi embedded

Thanks.

[v-lili6-msft]

hi, @Cobra77

     You may use Matrix visual to achieve it like below:

 

and if you want to hide a column with a parameter for the visual, I'm afraid it couldn't achieve it, maybe you could

try to use Row Level Security in data model in SSAS.

If you want column name of visual is dynamic?  You can do a dynamic in the data model in SSAS.

here is the blog and a similar case for you to refer to

Reference:https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-v...

https://community.powerbi.com/t5/Desktop/Dynamic-Formatting-Help-pictures-and-DAX-included/m-p/51209...

Best Regards,

Lin

[Cobra77]

hi @v-lili6-msft

I can not cross with an axis as in your example ( with A01, A02 etc ... )
For us each cell is a different measure.

Best regards, 

Stef