Forum Discussion
Linxys
3 years agoNew Member
Customized header grouped on 2 lines
Hi guys, I want to reproduce something like that in a matrix:
Buet my yitles are made by hand in Excel but I want to avoir any manipulation in Excel, any solution ?
Thanks !
6 Replies
- fooddCommunity Champion
The following guidance on working with Matric Visuals is helpful:
- https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
- https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
- LinxysNew Member
Doesn't really help me, my data is all in columm and the title cannot be set autoaticly but will be static in my visual.
- AnonymousNot applicable
This You can achieve with the help of data modeling and custom table
To achieve this Your data should look like as below. Then with the help of swith dax measure you can pass your result.
- LinxysNew Member
My data look more like this :
CODE_RSS Établissement DOMICILE CH Ri-RTF AUTRES CHSLD Total 640 633 182 116 246 a abc 239 173 68 44 26 b def 168 271 62 10 67 c ghi 138 176 20 14 36 d jkl 77 60 14 18 50 e mno 55 71 9 4 5 f pqr 54 16 12 7 64 g stu 46 54 14 4 36
- LinxysNew Member
bump
- LinxysNew Member
Data look like this :
CODE_RSS Établissement DOMICILE CH Ri-RTF AUTRES CHSLD Total 640 633 182 116 246 a abc 239 173 68 44 26 b def 168 271 62 10 67 c ghi 138 176 20 14 36 d jkl 77 60 14 18 50 e mno 55 71 9 4 5 f pqr 54 16 12 7 64 g stu 46 54 14 4 36