Matrice : Afficher les colonnes sans données

[Gwen]

Bonjour,

J’utilise une matrice pour faire un tableau (client / zone geographique (1 zone = 1 colonne) 

je souhaite afficher les zones de présence ou non.

problème : selon les filtres, les colonnes sans valeurs ne s’affichent pas. D’accord pour la logique.. puisque pas de donnée

Auriez vous  une façon de figer les colonnes quelques soit l’élément filtré?

Merci par avance de votre aide

[Gwen]

Merci !

[Gwen]

Hello

thank you for your answer

I try to explain the situation clearly : 

[lbendlin]

 If you want all areas to show you need to provide a dimension table that has all possible values.  You can create a calculated table in DAX for that if you like.

Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) .

[lbendlin]

If you have tables with relationships it depends which side of the relationship you pull the fields from, and if there are filters on the dimension table. Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.

[Gwen]

Hello,

Here is the database for example

Sorry for the delay but I did not know how to tie the link (suddenly I learned to do it) thank you for your help and have a nice day

Data4help 

[lbendlin · Accepted solution]

attached is a generic approach.  Both Rows and Columns now come from dimension tables and have "show items with no data"  enabled.