Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
attached is a generic approach. Both Rows and Columns now come from dimension tables and have "show items with no data" enabled.
Merci !
Hello
thank you for your answer
I try to explain the situation clearly :
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) .
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |