https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2107843#M32164 <P>Hello</P><P>thank you for your answer</P><P>I try to explain the situation clearly :&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Gwen_1-1632994332904.png" style="width: 790px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/603884i853A51594A3DCF75/image-dimensions/790x244?v=v2" width="790" height="244" role="button" title="Gwen_1-1632994332904.png" alt="Gwen_1-1632994332904.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 30 Sep 2021 09:33:44 GMT Gwen 2021-09-30T09:33:44Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2105350#M32138 <P>Bonjour,</P><P>&nbsp;</P><P><FONT>J’utilise une matrice pour faire un tableau (client / zone geographique (1 zone = 1 colonne)&nbsp;</FONT></P><P><FONT>je souhaite afficher les zones de présence ou non.</FONT></P><P><FONT>problème : selon les filtres, les colonnes sans valeurs ne s’affichent pas. D’accord pour la logique.. puisque pas de donnée </FONT></P><P><FONT>Auriez vous&nbsp; une façon de figer les colonnes quelques soit l’élément filtré?</FONT></P><P><FONT>Merci par avance de votre aide</FONT></P><P>&nbsp;</P> Wed, 29 Sep 2021 10:21:15 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2105350#M32138 Gwen 2021-09-29T10:21:15Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2106681#M32150 <P>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.&nbsp;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.</P> Wed, 29 Sep 2021 22:53:24 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2106681#M32150 lbendlin 2021-09-29T22:53:24Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2107843#M32164 <P>Hello</P><P>thank you for your answer</P><P>I try to explain the situation clearly :&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Gwen_1-1632994332904.png" style="width: 790px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/603884i853A51594A3DCF75/image-dimensions/790x244?v=v2" width="790" height="244" role="button" title="Gwen_1-1632994332904.png" alt="Gwen_1-1632994332904.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 30 Sep 2021 09:33:44 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2107843#M32164 Gwen 2021-09-30T09:33:44Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2108749#M32174 <P>&nbsp;If you want all areas to show you need to provide a dimension table that has all possible values.&nbsp; You can create a calculated table in DAX for that if you like.</P> <P>Please provide sanitized sample data in usable format (<STRONG>not as a picture</STRONG> - inserting it into a table would be good) .</P> Thu, 30 Sep 2021 17:29:02 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2108749#M32174 lbendlin 2021-09-30T17:29:02Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2115822#M32232 <P><SPAN>Hello, </SPAN></P><P><SPAN>Here is the database for example </SPAN></P><P><SPAN>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</SPAN></P><P><A title="Data4help" href="https://aneoconsulting-my.sharepoint.com/:x:/g/personal/gvaillant_aneo_fr/ER3uu-J7o4RGlJAQHrIpX1kBnkPdmRpa4ABCjgAQtDtiSw?e=B2yH34" target="_self">Data4help</A>&nbsp;</P> Tue, 05 Oct 2021 09:36:46 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2115822#M32232 Gwen 2021-10-05T09:36:46Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2116197#M32238 <P>attached is a generic approach.&nbsp; Both Rows and Columns now come from dimension tables and have "show items with no data"&nbsp; enabled.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lbendlin_0-1633438275707.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/606678i56124AF1AE447FDF/image-size/medium?v=v2&amp;px=400" role="button" title="lbendlin_0-1633438275707.png" alt="lbendlin_0-1633438275707.png" /></span></P> <P>&nbsp;</P> Tue, 05 Oct 2021 12:51:24 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2116197#M32238 lbendlin 2021-10-05T12:51:24Z https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2116331#M32240 <P>Merci !</P> Tue, 05 Oct 2021 13:40:12 GMT https://community.fabric.microsoft.com/t5/Developer/Matrice-Afficher-les-colonnes-sans-donn%C3%A9es/m-p/2116331#M32240 Gwen 2021-10-05T13:40:12Z