cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cobra77 Member
Member

is it possible to make this big cross table ?

hi

 

is it possible to make this big cross table ?

 
 
CB.jpg
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.
2 REPLIES 2
Community Support Team
Community Support Team

Re: is it possible to make this big cross table ?

hi, @Cobra77

     You may use Matrix visual to achieve it like below:

4.PNG 

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Cobra77 Member
Member

Re: is it possible to make this big cross table ?

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